Post reply

SQL maintenance plans with 'Run as' user deleted from AD

  • June 4, 2014 at 9:12 am

    #292022

    Hi all,

    first post here @_@

    I have three maintenace plans - Full backup, Index Defrag, Index Rebuild ... all created under a AD user that got deleted in the meanwhile,

    windows event log:

    "SQL Server Scheduled Job 'Altiris DB - Index Defrag Task.Subplan' (0xD5D7F8561C6D194EB84A2757DD5E91B2) - Status: Failed - Invoked on: 2014-06-04 02:00:00 - Message: The job failed. The owner () of job Altiris DB - Index Defrag Task.Subplan does not have server access"

    How do I modify these tasks that now error out when trying to run as scheduled?

    Thanks!

  • June 4, 2014 at 9:18 am

    #1718877

    Have you tried changing the associated Jobs owner to 'sa'?

  • June 4, 2014 at 9:18 am

    #1718878

    They are listed as separate jobs in SQL Agent Jobs.

    You have to open each one and change the owner to a new AD user.

    Alex S

  • June 4, 2014 at 9:27 am

    #1718881

    1. in Jobs - job owner was already sa

    2. in Jobs - when I changed from sa to my AD account only found 'NT AUTHORITY\SYSTEM'

    ...?

  • June 4, 2014 at 11:37 am

    #1718925

    alectronic (6/4/2014)

    1. in Jobs - job owner was already sa

    2. in Jobs - when I changed from sa to my AD account only found 'NT AUTHORITY\SYSTEM'

    ...?

    If you're not on the latest SP for SQL 2005 it's a bug so you should upgrade.

    http://support.microsoft.com/kb/969611

    Alex S

  • June 4, 2014 at 1:36 pm

    #1718982

    Microsoft SQL Server Management Studio9.00.4035.00

    Microsoft Analysis Services Client Tools2005.090.4035.00

    Microsoft Data Access Components (MDAC)2000.086.3959.00 (srv03_sp2_rtm.070216-1710)

    Microsoft MSXML2.6 3.0 5.0 6.0

    Microsoft Internet Explorer7.0.5730.13

    Microsoft .NET Framework2.0.50727.3655

    Operating System5.2.3790

  • June 4, 2014 at 2:32 pm

    #1719006

    At this point, I would just delete those existing 3 Maintenance plans and recreate them from scratch. 🙂 😎

  • June 4, 2014 at 2:43 pm

    #1719017

    sreekanth bandarla (6/4/2014)

    At this point, I would just delete those existing 3 Maintenance plans and recreate them from scratch. 🙂 😎

    After several tries, this is what I've done, will be running them overnight.

  • June 4, 2014 at 3:17 pm

    #1719038

    PS

    is there a way of comparing the two tasks, old versus newly created? I'm not sure I ~cloned~ them exactly.

Viewing 9 posts - 1 through 8 (of 8 total)

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