Pages

Banner 468 x 60px

 

Sunday, 9 September 2012

A network-related or instance-specific error occurred while establishing a connection to SQL Server


After install SQL server 2008 in my machine I try to connect sql server using my machine IP Address in that time I got error 
                                                                                                    
TITLE: Connect to Server
Cannot connect to xxx.xxx.xxx.xxx
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: 5)



Now I will explain How to solve the error by step by step
Step 1
            Click start-> All Program->Microsoft SQL Server 2008->Configuration Tools->click on SQL Server Configuration Manager

 Expand SQL Server Network Configuration Double click Protocols for SQLEXPRESS and Right click on t TCP/IP and select Enable
It will ask you to restart SQl server

Already I will explain How to restart the SQL server in following post

No comments:

Post a Comment