Print Page | Close Window

SQL db transfer error

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=16461
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL db transfer error
Posted By: iSec
Subject: SQL db transfer error
Date 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.


-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard



Replies:
Posted By: dj air
Date 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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net