SQL Server Agent Service account locked out

  • 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 ][/url]http://sivasql.blogspot.com/[/url]

  • 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."

  • i have one question how the SQL Server Agent Service account were locked out.

    ..>>..

    MobashA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply