After changing my PC name and workgroup, I am no longer able to connect to SQL Server.

Currently in my servers list I have only Home & localhost. Anybody know how to add server to networks list?

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: 53)

The network path was not found

migrated from stackoverflow.com Aug 22 '14 at 14:32

This question came from our site for professional and enthusiast programmers.

  • 2
    Very common problem. Microsoft even created a special article just for that: msdn.microsoft.com/en-us/library/ms143799(v=sql.110).aspx – Ennor Aug 22 '14 at 13:28
  • 1
    What is "my servers list"? Where are you seeing this list? Can you tell us what you see under SQL Server Configuration Manager > SQL Server Services? Is there a SQL Server instance (running!) and does it say (MSSQLSERVER) or (some other instance name afterward)? – Aaron Bertrand Aug 22 '14 at 21:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy