Okay, I thought I found a great resource (it's still good just not complete) for upgrading to DNN 4.8. I have followed the instructions line by line, all four pages and everything went well until I tried to hit the ..../Install/Install.aspx file to initialize the upgrade.
I get an error.... of course...
Error Installing DotNetNuke
Current Assembly Version: 04.08.00
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
So in my research I read I needed to comment out the "sqlexpress" comment, but it didn't work. Plus it's in the old web.config file anyway, and it worked there. So here is what I have, can anyone tell me what I am missing?
</configSections>
<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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"
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="Data Source=SQLB16.WEBCONTROLCENTER.COM;Database=DotNetNuke;uid=(XXXXXXX);pwd=(XXXXXXXX);"/>
-->
Am I that dumb and can't see this or is looking at it now for 8 hours causing the problem? Any bit of help or advice would be great!