FreeTDS Development Group

["Black Elena (AMUNDI-PIONEER.USA)" <elena.black AT amundipioneer.com>]

Hello:
Thanks for the assistance! I'm going through all your suggestions. But still 
no luck. I know I'm missing one small thing somewhere.

If I turn SSL off at the database, and make no changes, freeTDS.conf,  
freeTDS connects fine and runs the scripts.

Even with these settings in the freeTDS.conf

[ServerName]
  host = XXXXX
  port = XXXX
  encrypt = request
  ca file =  XXXX/XXX/freetds/etc/xxxx_xx_xx_xxxxx_xxxxx_xx.pem

Elena Black
Sr. DBA Administrator
60 State Street
Boston, MA 02109 
Web: www.amundi.com
Tel: +33 1 617 697-8213
@: elena.black AT amundipioneer.com
Amundi Pioneer
A company of the Amundi group 

Visit us on: 

        

-----Original Message-----
From: FreeTDS 
<freetds-bounces+elena.black=amundipioneer.com AT lists.ibiblio.org> On Behalf 
Of Frediano Ziglio
Sent: Friday, June 26, 2020 11:59 AM
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [Marketing Mail] Re: [freetds] [Marketing Mail] Re: Microsoft SQL 
Server 2016 SSL

Hi,

Il giorno mar 23 giu 2020 alle ore 20:08 Black Elena (AMUNDI-PIONEER.USA) < 
elena.black AT amundipioneer.com> ha scritto:

> Hi thank you for your assistance and sorry for the late reply.
>
> To clarify, if using SQL Server 2016, the highest version that it 
> supports is 7.4? We are using version 8.0 so I need to override the 
> version in the .conf file?
>
>
Last version of the protocol is still 7.4, also for MSSQL 2019. Microsoft 
moved to feature extensions not bumping protocol versions.
Latest FreeTDS versions default to "auto" as protocol version which will work 
using the latest protocol version available.

I have tried the following settings:
>
> host = ClusterResourceName
>   port = xxxx
>   tds version =  7.4
>   instance = MSS_SSLINSTANCE_XXX
>   encryption = request
>
>
Either port or instance. Port is faster.


> none seem to work.
>
> I CAN ping the server. Am working on getting telnet allowed through 
> the firewall. That will be tomorrow. Also, the settings for the conf 
> file are stored in a Mysql db, it gets overwritten whenever we add in 
> a new instance, which is yet another issue that I will have to work 
> through because the ssl settings that I set up in the .conf file get 
> removed when a new instance is added. I can see the sql that is used 
> to write the file, it only takes the server/hostname and port no other 
> settings are brought forth.
>
>
If you cannot telnet (or netcat or other tool) at mssql port you simply 
cannot connect.

Frediano

Elena Black
> Sr. DBA Administrator
> 60 State Street
> Boston, MA 02109
> Web: www.amundi.com
> Tel: +33 1 617 697-8213
> @: elena.black AT amundipioneer.com
> Amundi Pioneer
> A company of the Amundi group
>
> Visit us on:
>
>
>
> -----Original Message-----
> From: FreeTDS <freetds-bounces+elena.black= 
> amundipioneer.com AT lists.ibiblio.org> On Behalf Of Frediano Ziglio
> Sent: Friday, June 19, 2020 11:44 AM
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> Subject: [Marketing Mail] Re: [freetds] Microsoft SQL Server 2016 SSL
>
> Il giorno ven 19 giu 2020 alle ore 15:04 Black Elena 
> (AMUNDI-PIONEER.USA) < elena.black AT amundipioneer.com> ha scritto:
>
> > Hi
> >
> > I set up SSL on an instance of MS SQL Server 2016. Confirmed that 
> > all connections (using SQL Server Management Server as a first step) 
> > were encrypted. I changed the flag,  Force Encryption to yes on the 
> > instance.
> > The Certificate is set up as in the documentation using the Server 
> > name as CN (I am going to add a different instance using the CN as 
> > the sql server network resource name, am waiting on that).
> >
> > I set up an entry (manually) in the freeTDS.conf file as follows:
> >
> > INSTANCE_NAME
> > freeTDS version 8.0
> > encryption = true
> > Port 1453
> >
> > The error I get is:
> >
> > Error, failed to connect to INSTANCE_NAME !!!<br> <pre 
> > style="font-size:12px; 
> > font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; 
> > background-color:white;">
> > FreeTDS: db-lib: exiting because client error handler returned 
> > INT_EXIT for msgno 20002
> >
> > Can someone assist?
> >
> > Thank you!
> >
> > [cid:89B49E07-4580-47BA-A59D-B0A59F32E6C5]
> >
> > Elena Black
> > Sr. DBA Administrator
> > 60 State Street
> > Boston, MA 02109
> > Web: www.amundi.com
> > Tel: +33 1 617 697-8213
> > @: elena.black AT amundipioneer.com
> > Amundi Pioneer
> > A company of the Amundi group
> >
> >
> Hi,
>   see http://www.freetds.org/userguide/ChoosingTdsProtocol.html and 
> http://www.freetds.org/userguide/freetdsconf.html.
> Also try to solve with http://www.freetds.org/userguide/serverthere.html.
>
> Regards,
>   Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
https://lists.ibiblio.org/mailman/listinfo/freetds