FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016

When you repair a SQL Server 2016 installation in the following scenarios:
  • You sign on to Windows as a user who is not a member of SQL Server Administrators.
  • The SQL Server service is stopped.
In either of the preceding scenarios, during the repair progress SQL_Telemetry_LoginRepair_Startup_Cpu64, you may receive an error message in a pop-up window that resembles the following:
Microsoft SQL Server 2016 Setup
The following error has occurred:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
Note If you click Cancel to close the pop-up window, the repair can still finish successfully.

The issue was first fixed in the following cumulative update of SQL Server: Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology that Microsoft uses to describe software updates.

Article ID: 3174829 - Last Review: 07/25/2016 23:37:00 - Revision: 1.0

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3174829