Common error after installation of MS SQL server 2012
After installation of MS SQL Server 2012 on Windows Server 2012, I had gotten these errors in Event Viewer on execution server:
The server was unable to initialize encryption because of a problem with a security library. The security library may be missing. Verify that security.dll exists on the system.
TDSSNIClient initialization failed with error 0x139f, status code 0x80. Reason: Unable to initialize SSL support. The group or resource is not in the correct state to perform the requested operation.
TDSSNIClient initialization failed with error 0x139f, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The group or resource is not in the correct state to perform the requested operation.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I must notice that I had an old distributive of MS SQL Server 2012.
The solution to fix it is easy – you need to install the update of SQL Server. You can download it from https://support.microsoft.com/en-ca/help/3135244/tls-1-2-support-for-microsoft-sql-server
The reason is connected with early version of Transport Layer Security (TLS). TLS version must be 1.2 or higher.