Web Wiz Forums - Error about permission on SQL server?

Print Page | Close Window

Error about permission on SQL server?

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=14082
Printed Date: 12 April 2026 at 3:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error about permission on SQL server?

Posted By: faca5
Subject: Error about permission on SQL server?
Date Posted: 03 March 2005 at 5:39am

How I can resolve this error!? I look on " file:///D:/!!!/Documentation%20and%20FAQs/common_errors.htm - Troubleshooting and Common Errors " but is nothig written about this.

The database is successfuly create? But about permission!?

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

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

-------------
http://www.studiofaca.com/" rel="nofollow - StudioFACA Portal :: http://www.renes.si/" rel="nofollow - Nepremičnine

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 March 2005 at 6:04am

You don't have permission to run stored procedures on the SQL Server.

Contact your web host.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dfrancis
Date Posted: 23 March 2005 at 10:22am

I've been looking at this and I have a question...

Wouldn't this problem be alleviated if the script crating the tables were re-written to this?

...strSQL = "CREATE TABLE [" & Request.Form("name") & "].[" & strDbTable & "Category] ("...

Posted By: WebWiz-Bruce
Date Posted: 23 March 2005 at 11:06am

Yes it would and in the next version work has already begun to change this.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dfrancis
Date Posted: 23 March 2005 at 11:17am

Thanks boRg!!!

I will modify my copy to make this correction... thanks for the confirmation.

Do you know of any other considerations regarding this change?

Posted By: dfrancis
Date Posted: 23 March 2005 at 11:54am

There were a few other places that needed to be fixed...

'*** Create indexes *****

And

'*** Create relationships *****

And

'*** Insert default values *****

And

'*** Stored Procedures *****

IT WORKED!

By the way, your code is wonderful!!!