Post reply

SQL Server Agent Service account locked out

  • May 22, 2008 at 10:23 pm

    #186979

    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]

  • May 23, 2008 at 1:23 am

    #819511

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

  • May 23, 2008 at 1:47 am

    #819518

    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