I currently have 1.9.5 RC1 installed, using a SQL 2008 database. I installed using the Microsoft Web App Gallery.
I am now trying to upgrade (I have tried to both 18.104.22.168 and 1.9.6). When I get to the part of the install where it tests the database connection, the test always fails with some form of the following error:
"Failure to attach to database." If I create a new connection string instead of using an existing one, I can get around this error.
However, then I get an error at the very end of the install saying it cannot create tables (starting with Thanks) on database 'master'.
This seems strange to me - why would it be creating new tables if it is an upgrade? For that matter, why won't the old connection string work?
If anyone could assist me in upgrading to 1.9.6 (or even 22.214.171.124) I would greatly appreciate it. Please let me know if any more info is needed from me, I know the error messages aren't entirely precise - I am trying to avoid breaking my forums again to duplicate the error unless I must.