Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Black Elena (AMUNDI-PIONEER.USA)" <elena.black AT amundipioneer.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [Marketing Mail] Re: Microsoft SQL Server 2016 SSL
  • Date: Tue, 23 Jun 2020 19:06:31 +0000

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




Archive powered by MHonArc 2.6.24.

Top of Page