Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute Permission denied on stored procedures intermittently Expand / Collapse
Author
Message
Posted Monday, December 08, 2008 10:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 17, 2009 9:23 PM
Points: 1, Visits: 8
We are receiving this error --- Execute Permission denied on stored procedures intermittently. We are baffled by this error since it only happens intermittently.

Example of the error:

The EXECUTE permission was denied on the object 'ProcGetEmailNotes', database 'ABCWF', schema 'dbo'.



The database is on a remote server (MS SQL Server 2005).


The web site is on a machine running under IIS default application pool using the Network Service account.


This account gets translated into DomainName\ServerName when accessing the remote database.


We gave this account db.owner permissions on the database.

Thanks,
choi
Post #615675
Posted Monday, December 08, 2008 11:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
Did you by any chance if you are not able to connect to the Domain Controller server to Authenticate the user? Thats the only thing I can think of.

-Roy
Post #615702
Posted Monday, December 08, 2008 11:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
are you qualifying the proc name when calling it?
Post #615707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse