FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016
Content provided by Microsoft
Applies to: Microsoft SQL Server 2016 DeveloperMicrosoft SQL Server 2016 EnterpriseMicrosoft SQL Server 2016 Enterprise Core
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:
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: