Post reply

Active directory DB/Agent Job owner

  • January 25, 2008 at 7:27 am

    #186059

    Hi all,

    I would like to know how an account deletion in Active Directory could affect a SQL server 2005 Agent Job and Database if this account is the owner of these two.

    Thanks in advance,

    Phil.

  • January 25, 2008 at 12:19 pm

    #771967

    The agent will verify the acct every time the job runs so if the acct is deleted in AD, then your job will fail until you change the acct.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • January 25, 2008 at 1:41 pm

    #772002

    Ok, here’s the situation:

    A company creates an AD account (UserA) for a consultant who’s in charge of installing BizTalk Server. During the installation, the consultant uses this account to run the setup process and use a different user (let’s say UserB) for starting SQL Server Service and the Agent Service. The installation setup process creates Databases and Agent Jobs in SQL Server. The owner of these databases and Agent Jobs is UserA.

    Then, a couple of months later, the company has decided to delete this AD account because UserA is no longer used anymore by any person.

    Is there a way to avoid this by only changing the owner of databases and Agent Jobs to another account after the setup process? If it’s the only way, which account should be used? DOMAIN\SQL Agent Service (which is defined by UserB in this example)?

    Thanks,

    Phil.

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

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