How to access sql server 2005 databse from client PC?
Posted on 2009-05-20
PC1 : I have SQL server 2005 database , Win XP, IP = 192.168.0.2
PC2 : windows 2000, IP = 192.168.0.59
PC1 and PC2 are connected to each other.
Enabled SQL server 2005 database for remote connection with protocol TCP/IP and Named pipe both.
Now I want to access/use the SQL server 2005 database from PC2.
my connection string is
But when I try to connect to the database it gives the error as below
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
How do I solve this problem?
Thanks in advance.