question

adilahmed avatar image
0 Votes"
adilahmed asked Cathyji-msft edited

'Test Connection Failed because of an error initializing provider ...... SSL Security Error' from Windows Server 2016

Hi In windows Server 2016 we deployed ASP .NET MVC web application to IIS,
From Server when we try to connect to SQL Server 2016 Database not connecting we tried the test connection using .UDL file, it gives
'Test Connection Failed because of an error initializing provider ...... SSL Security Error'
In Both SQL & Windows Server TLS 1.0,1.1 Disabled & TLS 1.2 Enabled.

Here what are the fixes from IIS Server to solve this issue?

sql-server-generalwindows-server-iis
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Make sure the UDL file is using a driver that supports TLS 1.2. Verify the application targets .NET 4.7 or later.

Installing SQL Server Native Client
Transport Layer Security (TLS) best practices with the .NET Framework


0 Votes 0 ·

Hi Please can you mention which driver UDL file will be use for supports TLS 1.2?

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @adilahmed,

Please make sure that you have enabled TLS 1.2. Beginning with Windows 10, version 1607 and Windows Server 2016, SSL 2.0 has been removed and is no longer supported. Refer to the MS document Protocols in TLS/SSL (Schannel SSP).

You can follow the steps from this MS document to enable TLS 1.2.

Quote from the similar thread, the solution is to install the SQL Server Native Client for SQL 2016.

The complete list of SQL Server and Client Driver builds, along with download links, and other configuration changes that may be needed are contained in the following Microsoft Support Knowledge Base article:
TLS 1.2 support for Microsoft SQL Server


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.