Pages

Saturday, January 29, 2011

Configuring Sql 2005 for remote connecions

I added a server machine and created a small home network. I tried to connect but recieved the following error message

TITLE: Connect to Server
------------------------------

Cannot connect to GAURAV-PC.

------------------------------
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

------------------------------
BUTTONS:

OK
------------------------------

The instance name as specified in the error to check was very correct but the other point had some doubts whether my SQL server on server machine is configured for remote SQL connections or not in fact it was not....

This is the best guide I got to resolve this issue

http://support.microsoft.com/kb/914277

1 comment: