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

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:
Recommendation: Install the latest cumulative update for 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.
Properties

Article ID: 3174829 - Last Review: Jul 25, 2016 - Revision: 1

Feedback