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)
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
Already I will explain How to restart the SQL server in following post




No comments:
Post a Comment