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 1.9.5.5 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 1.9.5.5) 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.

Thanks.

Usually it's enough to assign "dbowner" rights for the database during install in the user mapping for the db user specified.

If using a freshly installed 2008, make sure that SQL Server logins are allowed (default off using standard "next/next/next" install).

After the upgrade/install - the db user needs "datawriter, datareader" boxes checked in the user mapping, as well as "grant Execute" in the specific database Permissions so the stored procedures work.

Though if it worked on the initial install of 1.9.5 wouldn't that mean the user does have the rights? Or is it different for 1.9.5?

Thanks for the quick reply.

Since you are running your site without direct access to the SQL Server tools (ie Management Studio), maybe you should contact m6 to know if you have full control of your database(s) or not. Could be a provider restriction if they have upgraded the SQL Server lately.

I am myself running with full control of the Win server & SQL Server, so I am maybe not a good reference to talk about issues in a remotely hosted environment.

However, if the "Thanks" table was introduced after 1.9.5 (don't remember when...) , I think my comments in the earlier post are still valid, so you should contact m6 to resolve potential db rights issues, IMHO.

The fact that it's giving an error in the database "master" seems strange to me - that's not the name of my database. Is it possible that when YAF attaches its database to mine, "master" is the default one it looks for? My user definitely wouldn't have access to that, since it isn't the database I created for my forum.

As for the reason why it would look for some default database to attach to - maybe because I had to change my connection string?

I'm just spitting stuff out here, not really sure if any of that is possible or how to fix it if it is.

To me it indicates that you do not have rights to create tables in your database and falls back to the "default database" specified for the db user, which is the master db if you don't configure it.

I'd say it is a provider problem...

What does your connections string look like (leave out the pw and such if you post it here).

Mine is as simple as this and has worked since 1.9.4 (generic values for the parameters):

data source=(local);initial catalog=database-name;user=db_user;password=db_user_password

Of course the data source parameter has to point to the SQL Server machine if the db server is on a different machine than the web server.

New version of db.config gets uploaded when I install the new version, same with app.config.

So in addition to merging the web.config files, I had to fix those files too.

I have successfully upgraded to 1.9.5.5, thanks for leading me in the right direction.

However, 1.9.6 still doesn't seem to work.

Error message is: Could not load file or assembly 'YAF.Classes.Config' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

1.96 is .NET 4.0 you need to change your application Pool to the Correct Pool. Of course you need to Have .NET 4 Installed on the Server to do that

If you have access to the server tools you would do that directlly in iis manager , if thats not possible i dont know if you can change that in the Admin Control Panel (or whatever this is called)of your hosting site. Or you have to ask your hosting Provider.