More info...
The upgrade was from v4.3.4 to v4.5.5 and the SQL server is 2000, not 2005 or 2005 Express.
I was able to get the site to come up by changing the web.config to comment out the the connections for SQL 2005 Express and to uncomment the ones for 2000 like so:
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" /> -->
<!-- Connection String for SQL Server 2000/2005 -->
<add
name="SiteSqlServer"
connectionString="Server=xxx.xxx.xxx.xxx;Database=xxxxxx;uid=xxxxxx;pwd=xxxxxxx;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User
Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> -->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=xxx.xxx.xxx.xxx;Database=xxxxxx;uid=xxxxxx;pwd=xxxxxxx;"/>
Now the site seems to come up fine however I never saw any upgrade messages or any kind of SQL upgrade so I'm not sure the upgrade is complete and I don't know what to check in the DB to see if it has or how to manually upgrade the DB if needed.
Any help?