I am setting up the forum on Server 2003 with SQL Server 2005.
During my install I get the following message: The database you are using needs to be upgraded !! Code : 80040E09
When I "Click here to upgrade the database." I'm taken to an admin logon page. When I key in the admin ID and password that I've chosen in the previous step I get the following error:
Microsoft OLE DB Provider for SQL Server error '80040e09' SELECT permission denied on object 'FORUM_MEMBERS', database 'VaultForum', owner 'dbo'. /setup_login.asp, line 78
I have verified in the SQL Enterprise manager that the forum tables do exist in the VaultForum database. I have also confirmed that the admin ID that I'm using is present in the table. The password was encrypted so I couldn't validate that. Just to make sure, I deleted the tables and went back a few steps to try again. Same messages.
I have a couple of questions. First, why would a brand new database need to be upgraded? Second, can anyone help:)
You probably need to set the default schema for your user (the one in the connection string) as db_owner, in SQL Server Management Studio. Try it and see if it helps.
So, your problem is really a permissions problem. Once you solve it, I would run setup.asp like this:
setup.asp?RC=5
Doing this should allow you to solve your problems.
Topic Locked
Posted - 19 May 2006 : 16:58:15
