Web Wiz Support and Community Forums : SQL db transfer error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 21:55:23 +0000 Wed, 07 Sep 2005 13:52:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16461 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL db transfer error : you need to either 1. get your...]]> https://forums.webwiz.net/sql-db-transfer-error_topic16461_post90117.html#90117 Author: dj air
Subject: 16461
Posted: 07 September 2005 at 1:52pm

you need to either

1. get your host to give you DBO permissions on the database and stored procedures

or 2

within the stored procedure pane, give your username execute permissions
]]> Wed, 07 Sep 2005 13:52:23 +0000 https://forums.webwiz.net/sql-db-transfer-error_topic16461_post90117.html#90117 <![CDATA[SQL db transfer error : I have recently changed hosting...]]> https://forums.webwiz.net/sql-db-transfer-error_topic16461_post90110.html#90110 Author: iSec
Subject: 16461
Posted: 07 September 2005 at 12:56pm

I have recently changed hosting provider, my forum is on an sql db so I went ahead and used the Import/Export tool offered by MS SQL Server. The transfer was all done but I keep getting the following error when trying to view my forum:
Quote Quoted MessageMicrosoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'justagu_test', owner 'dbo'.

/forum/common.asp, line 283

How do I fix that, thanks.
]]> Wed, 07 Sep 2005 12:56:23 +0000 https://forums.webwiz.net/sql-db-transfer-error_topic16461_post90110.html#90110