FIX: Error when you install SQL Server 2012 or SQL Server 2014 on a server that has TLS 1.2 enabled

Symptoms
When you try to install Microsoft SQL Server 2012 or SQL Server 2014 on a server that has Transport Layer Security (TLS) version 1.2 enabled, you may encounter the following issues:
  • If the version of SQL Server that you're trying to install doesn't contain the fix to enable TLS 1.2 support (for more information about the build that adds TLS 1.2 support, see KB 3052404), you receive the following error message:

    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
  • If the version of SQL Server that you're trying to install does contain the fix to enable TLS 1.2 support, you receive the following error message:

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
In both of these situations, the installation fails.
Cause
This issue occurs because SQL Server Setup uses SqlClient for ADO.NET from the .NET Framework 2.0. By default, the .NET Framework 2.0 works with TLS 1.0.
Resolution
To resolve this issue, install the hotfix rollup for the .NET Framework, and then restart the server. Use following table to find the appropriate hotfix, based on the operating system and SQL Server version that you're running:
Workaround
To work around this issue, follow these steps:
  1. Enable TLS 1.0 on the server.
  2. Restart the server.
  3. Run the SQL Server 2012 or SQL Server 2014 Setup program, and update the SQL Server version to a build that supports TLS 1.2. (For more information about the updates that add support for TLS 1.2, see KB 3052404.)
  4. Disable TLS 1.0.
  5. Restart the server.
Note When you try to install a build of SQL Server 2012 or SQL Server 2014 that doesn't contain the fix to enable TLS 1.2 support, you must also use this workaround.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3135769 - Last Review: 11/16/2016 17:31:00 - Revision: 3.0

Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Express, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Web, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web

  • kbfix kbqfe kbexpertiseadvanced kbsurveynew KB3135769
Feedback