FreeTDS Development Group

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

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?

I have tried the following settings:

host = ClusterResourceName
  port = xxxx
  tds version =  7.4
  instance = MSS_SSLINSTANCE_XXX
  encryption = request

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.

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