I have 2 DNN websites - both were running off databases from SQL2000 and have just been upgraded to SQL2005.
(running on different web servers).

The first one was upgraded sucessfully. However, I have a problem with the second one. The website doesn't load when trying to connect to my SQL2005 database.
Error message just says: Site Unavailable (default DotNetNuke message).

I followed the very same steps both databases:

1. Backed up sql2000 db.

2. Placed a copy of the above .BAK file on the SQL2005 server (in the same path/location as above.

3. Created a new database on the SQL2005 server (with the same name)

4. Restored the database (on SQL2005) using the copied .BAK file from the SQL2000 back up (from step 2 location)

5. Re-created the database user (which is the same for both, lets call the user NIGEL) and given dbo rights to the database user

6. Checked for any orphaned users, by using this script below:
EXEC sp_change_users_login 'Report'

7. Used this script to fix orphaned users:
EXEC sp_change_users_login 'update_one', 'NIGEL', 'NIGEL'

NOTE: in both databases - I did get NIGEL listed as an orphaned user, and the above script fixed it.

8. Re-run the script in step 6 again to check that orphaned users have gone.

9. Changed the connection string to point to the IP address of the new SQL2005 server (in web.config file).

SQL2005 INFO:
* Both databases have the db user 'NIGEL' listed under the database >> security >> users.

* Under the properties of this user on General Tab the username and default Schema is the same and db_owner is checked.

* Under the Securables Tab >> Execute permissions have been granted.

SECURITY >> LOGINS >> PROPERTIES >>
>> SERVER ROLES: Public is checked
>>User Mapping : User and Default Schema is the same for both
>> Status: Grant and enabled - are selected.

FURTHER INFO:
* I can ping the SQL2005 server ok from both web servers.
* If I replace the IP address in web.config back to the old SQL200 address the site runs ok.

I don't know what to check next.
Any ideas?

thanks in advance,
mark.

yes, tcp/ip is enabled on both web servers (it was running ok, connecting to the old sql200 database and still runs ok if i change the IP in the web.config file back to sql2000 ip address).

If I run the install file it gives me this error:

Installing DotNetNuke
Upgrade error: ERROR: Could not connect to database specified in connectionString for SqlDataProvider


(this also changes the machine config too, so I just replace it back the original machine config name)

thanks for your reply.

here is a sample of my web.config:

<add name="SiteMyNamedServer connectionString="Data Source=123.45.67.89;Initial Catalog=NIGEL;user ID=NIGEL;Password=MyPasswd" />
</connectionStrings>

<appSettings>
 <add key="SiteMyNamedServer value="Data Source=123.45.67.89;Initial Catalog=NIGEL;user ID=NIGEL;Password=MyPasswd" />

Do you think its related to the web.config file?
I can't understand why - with my first upgrade I only had to change the IP address in the web.config file.
So I was thinknig it might be something to do with sql2005, perhaps permissions or something.