Not Work Remote Server

winbala

New member
Joined
Mar 25, 2008
Messages
3
Programming Experience
1-3
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
 
Open up SQL Server 2005 Surface Area Configuration from the Start menu. Click on the Surface Area Configuration for Services and Connections link at the bottom of the form. Expand the MSSQLSERVER and Database Engine leaves and click on the Remote Connections node. Change from Local connections only to Local and remote connections.
 
Back
Top