I've got a DNN 5 site running on server 2008 r2 that has been running great on SQL Server 2005. I upgraded to 2008 including management studio and now I get the site unavailable page. I've checked the database under Management Studio and everything looks looks OK. I can open it in Studio with no problems. Any have any ideas, its a production site and I'm in a bit of a panic.

I got it working. I'm using the express version and connecting via SSMS. Not sure what I did to fix it but it was probably disconnecting the database in SSMS and the re-attaching it. I'm also having a problem with a DNN 6 site. It works great on my Vista workstation using SQL Server 2008 express and connecting vai SSMS. When I copy it up to the  2008 R2 server with IIS7 it comes up with the site unavailable, which I'm assuming is a database connection problem. If I do a clean install of  DNN 6 on the server it installs and runs fine. I compared the web config files and they look the same. I was hoping DNN 6 would give a more specific error rather than going to the unavailable page. Is there anyway to get more specific error info?

I've tried it as a file connection and connected through SSMS. Here are the connections:
file:
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

Through SSMS:
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Database=kessinger;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />

I put in a ticket and still no response from DNN