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

SQL Server Agent Service account locked out Expand / Collapse
Author
Message
Posted Thursday, May 22, 2008 10:23 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:46 PM
Points: 284, Visits: 263
When a SQL Server Agent Service account locked out what will be the impact on below?

1. Whether SQL Server Agent Service will up?
2. SQL Server Job owned by other than SQL Server Service account will get fire?


Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/
Post #505607
Posted Friday, May 23, 2008 1:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:56 AM
Points: 2,603, Visits: 2,061
Hello Siva,

Find your reply here:

1. When SQL Server Agent service account locked you can't restart the Agent but if agent is running no impact.
2. If agent is stoped no SQL Server job will fire.

Try this and double check in test environment.

GOODLUCK!


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #505651
Posted Friday, May 23, 2008 1:47 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, January 29, 2012 1:45 AM
Points: 710, Visits: 1,284
i have one question how the SQL Server Agent Service account were locked out.


..>>..

MobashA
Post #505658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse