SQlServer 2005 Not Connect Remote Server

Question

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

bala guru · Answer

already i done it. after that login user error come.. sql server 2005 does not allow remote connection.. what can i do

Scott Lysle · Answer

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.