Hi Michael,
I'm having trouble with a 4.0.3 to 4.3.0 UPGRADE. When I use the UPGRADE package, the upgrade completes, but I get the problem described here (Tikkune's post):
http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/107/threadid/44773/scope/posts/Default.aspx
Since I have yet to find a workaround for that Login problem, today I tried to do an upgrade using the INSTALL package. That upgrade does not work at all, and I immediately get this error:
Error Installing DotNetNuke
Current Assembly Version: 04.03.00
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
Searching on this error, I'm led to your post:
flanakin wrote
Check to ensure you can login to SQL Server using the user/password you specified in the conn string. Explicitly testing this will help verify that it works. If this isn't a problem, let us know.
I'm new to DNN and SQL. Would you kindly describe just how you explicitly test a connection. I'm using SQL Server Express 2005 (not MSDE), and so far as I know, I did NOT set a password on my Database.MDF either. I created the DB using MS SQL Server Mangement Studio Express, and I think during that setup I simply selected Windows Authentication (via the Administrator account). So in that way, my connection string:
<!-- 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" />
...makes the connection to the DB via the Admininstrator account, I presume. (Again, I know so little about SQL, I don't know for sure). Can you please share some specific steps for testing DB connections, and - if you have any suggestions resolving either install/upgrade failure I'm having, I would very much appreciate it. I ask you because on several searches for solutions to fix my upgrade troubles, your posts show up as near/close to my situation.
Incidentally, my 4.0.3 installation is working great; it's just this upgrade to 4.3.0 that's failing. I have followed all the instrucitons for using the new 4.3.0 release.config file, (not my old web.config file) and copying over my web.config Authentication and Encryption keys, then renaming the release.config file to web.config, then browsing to the website portal to start the upgrade.
Much thanks in advance.