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

Problem changing account for job execution Expand / Collapse
Author
Message
Posted Sunday, November 17, 2013 7:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 1:01 PM
Points: 46, Visits: 154
SQL Server 2012, some jobs are centralized from another server running SQL Server 2008 R2.

I'm having a problem getting jobs to run under the account I want. I've changed security settings and the account under which jobs previously ran no longer has sufficient privileges to run the jobs. I created a domain account and want to use it for all jobs.

I've set the new account as the MS Agent startup account on all servers. The job owner is in the sysadmin role on all servers. I've restarted the services. The jobs stubbornly continue to execute under the old account. Where else can I look to adjust the job runner account? Or, is there a way to discover why the jobs persist to run under the old account?
Post #1515054
Posted Monday, November 18, 2013 4:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 6:59 AM
Points: 232, Visits: 159
Check in the job step the run as option and see if the account is in the proxi used by the run as...
Post #1515170
Posted Monday, November 18, 2013 4:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 2,396, Visits: 2,933
If the job executes a stored procedure it is also possible that in the code of the stored procedure a "EXECUTE AS" is defined.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1515174
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse