| Author |
 Topic  |
|
|
Mort
Starting Member
4 Posts |
 Posted - 10 July 2005 : 17:58:52
|
Im using MSDE as database server for hosting my forum, so I don't have access to an Enterprise Damager, which kinda limits my troubleshooting capabilities.
I created a new empty database on my server and then created a server login and database user to let the forum access the database. I used the SA account to generate the database from the setup.asp page, which appeared to go fine (There was no error messages).
For some reason Im told that I now need to upgrade the database... When I try to do that, I am greeted with this friendly message:
quote:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'FORUM_TOTALS', database 'MyDatabase', owner 'dbo'.
/SomeFolder/SomeOtherFolder/default.asp, line 89
I'm guessing that the upgrade page attempts to use the regular forum user to manipulate some tables, instead of the SA user I specified when I created the database from the setup.asp file - But thats just a guess on my side.
Any ideas how to fix this, without any more database tools than the OSQL utility ? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 July 2005 : 18:09:16
|
| My guess is that the tables were not created, in the database, possibly because your user has no adequate server permissions. I would suggest that you use the sa user to create the database tables, and then change the connection string back to the normal user. That normal user needs to have an adequate database role. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 11 July 2005 : 03:10:32
|
If you have Access 2000+ you can use an Access Data Project to manage your MSDE database. It's much, much easier than OSQL.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Mort
Starting Member
4 Posts |
Posted - 11 July 2005 : 12:55:22
|
I tried setting the forum user to be SA and from that point everything worked. Unfortunately when I changed it back to the forum user, the forum stopped working again.
It appears that Snitz forum requires administrative rights to the database, in order to work. I don't feel quite comfortable running the forum as the database administrator, since this violates good database practice.
Are there nobody else who have succeeded in running the Snitz forum on an SQL server, without using administrative access to the database ? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 July 2005 : 13:35:42
|
| Does your user have dbowner role for the database? Also if you don't want him to have dbowner role, assign db_datareader and db_datawrite roles. That's all that's needed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Mort
Starting Member
4 Posts |
Posted - 13 July 2005 : 11:24:35
|
Ahh great, granting db_datareader and db_datawriter database roles to the forum user did the trick.
Thanks for the help :). |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
