I get the infamous message "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)"

We use:
windows server 2003
ms sql server 2000
The entire application runs locally, db and app are on the same server. This server is a vpc with in the vpc "local only".

The application used to work perfectly on our site, until we installed the latest version of this .net2 application. According to our Indian software developer, the new version of the application works perfectly on his site, and i believe him.

Virtually all posts on this topic i came across specify sql server 2005 features, and that does not a play a role here.
Of the remaining posts, most concern themselves with the connection string, but the connection string at our side remained unchanged (so did his, btw).

Any help would be greatly appreciated - our developers are as much at a loss as i am.

Some more Technical Info on it
There is one perticual SP for which it gives this perticular error( mentioned above by Teun).
We tried to change the SP name to check if the SP is having some problem. But the error is given before the SP is called.
Also all the other methods in this dataset are getting called without any error.

issue solved

Can you post the solution?

--

Joe (Microsoft MVP - XML)