I'm in the process of moving the websites that we manage and host from our old server (windows 2003 - iis6 with a remoote MS SQL 2008 daabase) to our new server - (windows 2008 web edition - IIS7 with local MS SQL Web Edition).
We also have some websites on a reseller account.
I have created copies of the existing databases on the new server.
I have changed the connection strings for the websites hosted on the reseller account, these connect to the database no problem.
I've changed the connection strings in dreamwaever, for the sites currently hosted on the old server (and tested the connection string in dreamweaver on my local pc) but, when i upload the new connection strings (to the old web server) and test the websites currently hosted on the old server I get the following error -
"Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/index.asp, line 19 "
I was hoping, because of the shear number of websites, just to change the database connection strings file, for each website on the old server, pointing to the new database.
So that I could then start the transfer of the actual websites over the weekend....
I really can't see what is causing this issue..