Web Wiz Forums - SQL Server error ’80040e09’

Print Page | Close Window

SQL Server error ’80040e09’

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=15975
Printed Date: 05 April 2026 at 1:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server error ’80040e09’

Posted By: keku24
Subject: SQL Server error ’80040e09’
Date 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

Replies:

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

Posted By: keku24
Date 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.

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

Posted By: keku24
Date 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.

Posted By: WebWiz-Bruce
Date 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

-------------
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