Web Wiz Support and Community Forums : SQL Server error ’80040e09’ https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 05 Apr 2026 13:23:17 +0000 Tue, 26 Jul 2005 03:10:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15975 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server error ’80040e09’ : The error means that the database...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87704.html#87704 Author: WebWiz-Bruce
Subject: 15975
Posted: 26 July 2005 at 3:10am

The error means that the database user 'DBO' doesn't have permission torun (execute) stored procedures on the SQL Server database.

Stored procedures are used on the MS SQL Server version, you will needto contact your web hosts and get them to set permissions for you torun stored procedures on the database
]]> Tue, 26 Jul 2005 03:10:25 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87704.html#87704 <![CDATA[SQL Server error ’80040e09’ : yepp, I first edit the &#034;S...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87703.html#87703 Author: keku24
Subject: 15975
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.
]]> Tue, 26 Jul 2005 01:21:06 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87703.html#87703 <![CDATA[SQL Server error ’80040e09’ : do you login to the SQL server...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87684.html#87684 Author: dj air
Subject: 15975
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.
]]> Mon, 25 Jul 2005 15:53:16 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87684.html#87684 <![CDATA[SQL Server error ’80040e09’ : But user&#034;DBO&#034; is the...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87682.html#87682 Author: keku24
Subject: 15975
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. ]]> Mon, 25 Jul 2005 15:47:38 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87682.html#87682 <![CDATA[SQL Server error ’80040e09’ : this means that the users account...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87677.html#87677 Author: dj air
Subject: 15975
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 executablepermissions for that user.
]]> Mon, 25 Jul 2005 14:40:29 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87677.html#87677 <![CDATA[SQL Server error ’80040e09’ : Help anyone? Microsoft OLE...]]> https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87675.html#87675 Author: keku24
Subject: 15975
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

]]> Mon, 25 Jul 2005 14:19:35 +0000 https://forums.webwiz.net/sql-server-error-80040e09_topic15975_post87675.html#87675