Error about permission on SQL server?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
faca5 Members Profile Find Members Posts Mod Builder Group Joined: 30 July 2003 Location: Slovenia Status: Offline Points: 187	Post Options Post Reply Quote faca5 Report Post Thanks(0) Quote Reply Topic: Error about permission on SQL server? Posted: 03 March 2005 at 5:39am
	How I can resolve this error!? I look on "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'.
	StudioFACA Portal :: Nepremičnine

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 03 March 2005 at 6:04am
	You don't have permission to run stored procedures on the SQL Server. Contact your web host.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply 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] ("...

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 23 March 2005 at 11:06am
	Yes it would and in the next version work has already begun to change this.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply 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?

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply 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!!!

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.