Skip to Content.
Sympa Menu

freetds - Re: [freetds] Microsoft SQL Server 2016 SSL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Microsoft SQL Server 2016 SSL
  • Date: Fri, 19 Jun 2020 16:44:01 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page