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

Question

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?

Answer 1

Hi @adil ,

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.

Answer 2

Test connection failed because of an error in initializing provider. Unrecognized database format 'C:\Users\Admin\OneDrive\Desktop\oldb files\Employee_4.xlsx'.