I got the below issue today. I surprised by seeing this message because
everything was working fine till last night. Suddenly, it was saying that
permission problem, configuration issue, instance typing mismatch and so on.
I guess most of the people
would have faced this issue. So, I want to blog this issue with solution to our
new bees.
TITLE: Connect to Server
------------------------------
Cannot connect to localhost.
------------------------------
ADDITIONAL INFORMATION:
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
Solution
(1) Start -> Run ->
Services.msc. Then, you can see services windows with listing of all services.
(2) Search for SQL Server
(MSSQLSERVER).
(3) Right click on that service
as shown in the below snag
(4) In the picture, you can see
a context menu with Start, Stop, and Pause etc... Options.
(5) Click on the Start menu
item. Then, you can see starting this service.
(6) Go back to Sqlserver
Management Studio (SSMS) and connect again.
(7) Then, you can see
connecting to the sqlserver successfully.
0 comments:
Post a Comment