SQlServer 2005 Not Connect Remote Server

bala guru

I Have developed my project vb .net and sql server2000.
now i want connect to that another system to that system. act this system using sqlserver 2005. when i connect to that system given error is coming

An Error Has occured while establishing a connection to the server.when connecting to the server 2005,this failure may be caused by that under the default settings sqlserver does not allow remote connections.(Provider:Named Pipes Provider,error:40 could not open a connection to sql server)

How to rectify that ..

Pls tell me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

bala guru18y ago
already i done it. after that login user error come.. sql server 2005 does not allow remote connection.. what can i do
Scott Lysle18y ago
Open up the Sql Server 2005 Surface Area Configuration tool, select remote connections, and configure the server to allow local and remote connections. See if that does not fix it.