SQL Server error ’80040e09’

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
keku24 Members Profile Find Members Posts Newbie Joined: 25 July 2005 Status: Offline Points: 3	Post Options Post Reply Quote keku24 Report Post Thanks(0) Quote Reply Topic: SQL Server error ’80040e09’ Posted: 25 July 2005 at 2:19pm
	Help anyone? Microsoft OLE DB Provider for SQL Server error '80040e09' EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'kelvina_forum', owner 'dbo'. /ciel/forum/common.asp, line 283

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 25 July 2005 at 2:40pm
	this means that the users account (SQL users) doesn't have access/execute permssions for that stored procedure you need ot allow dbo privelages for that account or change the owner, or edit each stored procedures access options to allow executable permissions for that user.

keku24 Members Profile Find Members Posts Newbie Joined: 25 July 2005 Status: Offline Points: 3	Post Options Post Reply Quote keku24 Report Post Thanks(0) Quote Reply Posted: 25 July 2005 at 3:47pm
	But user"DBO" is the hoster username. I am trying to figure out how to granted myself permission on write/read the table. the table was created using the setup script from the forum.

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 25 July 2005 at 3:53pm
	do you login to the SQL server (within the SQL_server_connection.asp) file using dbo? or do you ave something different if something different that needs access (execute rights) enabled.

keku24 Members Profile Find Members Posts Newbie Joined: 25 July 2005 Status: Offline Points: 3	Post Options Post Reply Quote keku24 Report Post Thanks(0) Quote Reply Posted: 26 July 2005 at 1:21am
	yepp, I first edit the "SQL_server_connection.asp" to strSQLServerName = "66.xxx.xxx.xx" strSQLDBUserName = "My_Login" strSQLDBPassword = "MyPassword" strSQLDBName = "kelvina_forum" I setup the table by usiing "msSQL_server_setup.asp". I follow the installation instruction step by step.

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: 26 July 2005 at 3:10am
	The error means that the database user 'DBO' doesn't have permission to run (execute) stored procedures on the SQL Server database. Stored procedures are used on the MS SQL Server version, you will need to contact your web hosts and get them to set permissions for you to run stored procedures on the database
	Web Wiz Forums Hosting ASP.NET Web Hosting

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.