Please Help! I'm trying to move a DNN 5.06.08 site from a production server to a new production server.

Existing server is Windows Server 2003/IIS6 with SQL Server. New server is Windows Server 2008/IIS7with SQL Server. The DNN root portal has aliases for both the new machine name and localhost. I have tried both copying the existing database to the new server and backing the database up and restoring it to the new server.

The database shows up in SQL Server Manager. I can connect to it using my domain credentials.

Whenever I browse to the site, the installation wizard kicks in and says it can't connect to a valid database. The wizard passes the permissions test. On the database connection page I get this error:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed

I've tried every combination I can think of using local, machine name and IP for the server. The folder (App_Data) has read/write rights for the application pool, Network Service - even Everyone.

Any suggestions would be greatly appreciated - I have 200 teachers showing up for work on Monday who will want to edit their web sites!

Thanks,

Jerry

Hi Mike,

I'm trying to use integrated security. My user account is set up as a SQL Server login with owner permissions on the database.

I'm also able to connect to the database from my local testing server. But I've tried to upload that successful page to our production server and the connection is being refused. Supposedly SQL Server on the new machine is set up to allow remote connections so I'm not sure where that problem is. Digging into it now...

Thanks!