I am currently developing a 2.0 asp.net application from my home pc (Windows XP) and am trying to connect to a sql server on my host. This works fine at work but at home I just get the following error message:
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)
Any ideas, i have even tried disabling my firewall to see if that made a difference.
Your help is much appreciated.
Under SQL2005 program menu follow configuration Tools =>SQL Server Surface Area Configuration => Select Server Surface Area Configuration for Services and Connections.
It will lead to a window with a treeview select Remote connections.Then Select Local and Remote Connections.
Thats it now you can connect your SQL Server without any problem
|||Thanks for the reply, however, it seems as if the problem was with the router i was using. After making some port changes it works just fine.
Thanks
No comments:
Post a Comment