Web Wiz Support and Community Forums : Error logging in to v7.97 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 05:10:56 +0000 Sat, 04 Mar 2006 12:45:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18581 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Error logging in to v7.97 : Version 8 does address this issue...]]> https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100578.html#100578 Author: WebWiz-Bruce
Subject: 18581
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.]]> Sat, 04 Mar 2006 12:45:26 +0000 https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100578.html#100578 <![CDATA[Error logging in to v7.97 : More and more web hosts are restricting...]]> https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100550.html#100550 Author: dpyers
Subject: 18581
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.]]> Sat, 04 Mar 2006 00:54:02 +0000 https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100550.html#100550 <![CDATA[Error logging in to v7.97 : Version 7.97 uses stored procedures...]]> https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100516.html#100516 Author: WebWiz-Bruce
Subject: 18581
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.]]> Fri, 03 Mar 2006 14:07:04 +0000 https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100516.html#100516 <![CDATA[Error logging in to v7.97 : I had played with the beta version...]]> https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100515.html#100515 Author: gdfellows
Subject: 18581
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.
 

 

]]> Fri, 03 Mar 2006 13:07:38 +0000 https://forums.webwiz.net/error-logging-in-to-v7-97_topic18581_post100515.html#100515