“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) (Microsoft SQL Server, Error: 2)”
You may encounter an error message when connecting to SQL Server Instance.
There are several reasons why you might get this error.
- You may not have specified the SQL Server name correctly.
- The SQL Server name that you specify is correct; but the SQL Server service is not running.
- You may not have opened SSMS with Run As Administrator.
- You may not have the necessary privileges on the port on which SQL Server is running.(you should check your company’s firewall).
The problem will be solved when you are sure that the above steps are correct.