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

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


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.

Resolution


The issue was first fixed in the following cumulative update of SQL Server:

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.