Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - EXECUTE permission denied on object ?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

EXECUTE permission denied on object ?
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
zadax View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zadax Quote  Post ReplyReply Direct Link To This Post Topic: EXECUTE permission denied on object ?
    Posted: 29 April 2004 at 7:12am
 

 

 

maybe my common file is currept ?

i have 7.5 acces i used the upsize tool to make it sql than i used the

Setup sql asp page it run with no error than i tried run the forum

and i got that msg :

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

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

/Forum/ver9/common.asp, line 265

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 29 April 2004 at 7:52am
You do not have permisison on the MS SQL Server to run the stored procedures. Contact your hosting company.

Make sure your MS SWQL Server login is part of the dbo group, your host may need to change this for you.


Edited by -boRg-
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 29 April 2004 at 12:41pm
A lot of hosts are locking down the dbo group. I've been able to change dbo in the SP's to a db login and run the forum with no apparent problems.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 23 March 2005 at 9:45am
Originally posted by dpyers dpyers wrote:

A lot of hosts are locking down the dbo group. I've been able to change dbo in the SP's to a db login and run the forum with no apparent problems.
 
more info?
 
I'm getting that same error
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 23 March 2005 at 11:07am
The simplest way is to do a search and replace on the SQL server setup file to replace all instences of DBO with your login credentials.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
tk123 View Drop Down
Newbie
Newbie


Joined: 20 July 2005
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tk123 Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2005 at 5:41pm
Can someone provide an example?
 
When I find something like "CREATE TABLE [dbo]..." What do I put instead? "..[username:password].."?
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2005 at 8:24pm
change dbo to the user/account name for the mssql db you set up.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 20 July 2005 at 8:27pm
Forgot to add...
IIRC, the mssql set up for 7.9 allows tyou to specify the sql server login/password. You don't have to use dbo. Don't recall if that was a feature of 7.5 though.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
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.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.