I'm using VS2005 & SQL Server 2005 which is installed with VS2005.
Platform is XP SP2.
I've an app that connects to the DB & get some data from it .
The app & DB are on the same machine .
Suddenly When I run the app. , I've that error :
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)
I've searched over the net for that problem & I've done what others did:
1- Enable Remote Connection:Using both TCP/IP & named pipes.
2- Maker sure that the service is running .
3- Add exceptions to the firewall
Then after that ,I'm still facing the same problem .
After all trials ,I've uninstalled VS2005 & all it's component .
After installing it again ,I've the same problem .
So the Solution is ....?!!