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

after applying SP2 to SQL Server 2008 R2 receiving execute permission denied in msdb - account has sysadmin Expand / Collapse
Author
Message
Posted Wednesday, February 19, 2014 11:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:41 AM
Points: 4, Visits: 7
Applied SP2 to SQL 2008 R2 stand alone machine. The Domain ID is sysadmin and is the ID that both the SQL Server service and agent accounts run under. When the job executes "The Execute permission was denied on the object 'sp_update_job'.... The job seems to complete fine with the exception of failing with the output having the permission error. No errors in the SQL Log or the SQL Agent log.
Post #1543158
Posted Wednesday, February 19, 2014 1:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
I would check the errorlog immediately after the upgrade when the instance was in script upgrade mode and make sure there are no errors in there.

---------------------------------------------------------------------

Post #1543207
Posted Wednesday, February 19, 2014 1:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:41 AM
Points: 4, Visits: 7
No errors in the SQL Server Log.
Post #1543209
Posted Wednesday, February 19, 2014 2:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:41 AM
Points: 4, Visits: 7
FYI... I dropped and recreated the job. The errors have now stopped.
Post #1543227
Posted Wednesday, February 19, 2014 2:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
interesting, thanks for posting back solution. was it just the one job with the error, others were OK?

---------------------------------------------------------------------

Post #1543235
Posted Monday, February 24, 2014 9:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 24, 2014 9:41 AM
Points: 4, Visits: 7
The others were working fine; which is why the error made no sense...
Post #1544612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse