topic Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection in Connectivity & Data Prep

Unable to connect to SQL Server using "Microsoft SQL Server" connection

cjmckenna — Fri, 10 Dec 2021 20:29:42 GMT

We recently updated our database server to only use TLS 1.2. When we did that, our existing OLEDB connectors to Microsoft SQL Server stopped working. After looking into this, it looks like the OLEDB drivers do not support TLS 1.2, so I am trying to change these connections over to the MSOLEDBSQL version of this connection. However for the life of me, I cannot get this connection to work. I am able to connect just fine using SSMS, and the old OLEDB connectors worked fine until we disabled TLS 1.2. However I am getting a "cannot find server" generic error when creating the connection with the Microsoft SQL Server connection.

I did some digging around and found that our DB server is using dynamic ports, so I tried specifying the same port:

Here is what my MS SQL Server connection looks like:

I'm out of ideas, any help would be appreciated!

Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection

bsullivan28 — Tue, 23 Jun 2020 21:35:07 GMT

Were you able to find a solution?

Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection

MChapp — Wed, 30 Sep 2020 14:39:13 GMT

Any updates on this issue? We are currently experiencing a connectivity issue to Microsoft SQL Server after the June 2020 SR3 upgrade

Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection

Sera — Mon, 19 Oct 2020 08:28:53 GMT

We are experiencing the same problems, after June 2020 SR3 update...

Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection

tvisha — Tue, 25 May 2021 09:58:46 GMT

Any updates on this. I am facing the same issue. Thanks,

Re: Unable to connect to SQL Server using "Microsoft SQL Server" connection

PadmaPriya — Tue, 25 May 2021 14:00:32 GMT

Hello @tvisha

May I know what is the error you are facing?
Do you have TLS 1.1 or 1.2 enabled?
Have you enabled ipv4 and are you using static default port 1433 or dynamic port?
In services.msc please check the service account of SQL Server.

Thanks,

Padma Priya