I have 5 separate DNN installations. Due to resource/performance issues, I moved the MS-SQL-2005 databases from server 1 to server 2.  Those sites that were moved are now performing well. I guess MS-SQL & IIS don't play well together.

I backed up each site and restored the backup to the MS-SQL server on server 2. Updated the IP address in the web config. 4 Sites were successful. The last site, I get this 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 have quaddrouple checked the web config to ensure that the connection string is correct.  (Each site has a separate SQL logon and password).  When I use the log on creditials from the remote server via a VB Script, it connects without a problem. It is only this one DNN install that is causing a problem. I have been searching but yet to find a solution.

Has anyone experienced this?