| Author |
 Topic  |
|
|
dalthen
Starting Member
2 Posts |
 Posted - 08 October 2003 : 12:51:26
|
I just downloaded the latest release of Snitz and it's running on:
Windows 2003, SQL 2000 SP3 and IIS 6.0
Initial setup ran fine; however, now I'm getting a message that reads:
The database needs to be upgraded !!
The database you are using needs to be upgraded !!
Code : 80040E09
When I click on Update the Database link; I get prompted for the forum's admin name and password. I enter this information and I get the following error message:
Microsoft OLE DB Provider for SQL Server error '80040e09'
SELECT permission denied on object 'FORUM_MEMBERS', database 'Forum_DB', owner 'dbo'.
/forum/setup_login.asp, line 82
No matter what username I use, I keep getting this error message.
Any ideas as to how to go about this message?
Thanks :) |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 October 2003 : 12:52:54
|
| sounds like the SQL User that you specified in the strConnString in the config.asp file doesn't have enough permissions to access the DB correctly. |
 |
|
|
dalthen
Starting Member
2 Posts |
Posted - 08 October 2003 : 13:02:40
|
| He's got all permissions checked for the database. Is there something else I need to add besides the 9 db_ permissions? |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 October 2003 : 13:09:36
|
| Can you check you database and see if there are 2 copies of each of the tables? I seem to remember a situation one time where there were 2 copies of the tables, 1 with dbo as the owner, and 1 with a different user as the owner. It's definitely some sort of mis-configured permissions problem though. |
|
|
|
Philnguyen44
Junior Member
164 Posts |
|
|
jbahr109
Starting Member
USA
1 Posts |
Posted - 19 March 2004 : 09:50:00
|
I'm having the same problem. In fact, this is the third Snitz setup I've done, and it's always a pain in the tail to get it connected to SQLServer correctly.
The DB name is QED, the owner is QED, QED is the login name, all permissions have been manually set in Properties, I have no problem with the login. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
