Web Wiz Forums - Error logging in to v7.97

Print Page | Close Window

Error logging in to v7.97

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18581
Printed Date: 13 April 2026 at 6:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error logging in to v7.97

Posted By: gdfellows
Subject: Error logging in to v7.97
Date Posted: 03 March 2006 at 1:07pm

I had played with the beta version 8.1, and all worked fine. However, I have not been successful at getting the production release 7.97 working correctly.

I created a new SQL database and ran msSQL_server_setup.asp. It replies:

Congratulations, the SQL Server Forum database is set up and Ready to Go :)

Then, when I try to login, I get the following error message:

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpCategoryAll', database 'gdfello_webwiz7', owner 'dbo'.
/forum7/default.asp, line 133

I am not a SQL expert (obviously!), so any help would be appreciated.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 March 2006 at 2:07pm

Version 7.97 uses stored procedures which require that your SQL Server login is part of the DBO group.

Posted By: dpyers
Date Posted: 04 March 2006 at 12:54am

More and more web hosts are restricting the dbo account. Two ways I work around it are to either edit the db creation sql code to change the owner of procs and other objects to my db user id or to go in after the creation with enterprise manager and add my db account id as owner of the objects. Changing the sql code is a lot less tedious.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: WebWiz-Bruce
Date Posted: 04 March 2006 at 12:45pm

Version 8 does address this issue by allowing the user to enter a different user group when running the database setup file.