Pages

Subscribe:

Ads 468x60px

Friday, 25 January 2013

Connect to Server - SQL Server Connecting Issue


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
ISSUE


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