FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

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
>