Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck.
I always have this error message: Microsoft SQL Native Client: 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.
I've followed the instructions at this link ->http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems.
I've already adjusted my firewall settings.
What should I do?
Please help me...
Hi,
Make sure that the servername, username and password are correctly configured in your config file. Try checking that by accessing the DB locally on the server itself.
HTH,
Vivek
|||Make sure your connectionstring is correcthere and TCP/IP and named pipes is enabled check this:SQL Server Troubleshooting .
Hoep it helps.
