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

  • 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!

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

  • 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
  • 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'

    ...?

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

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

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

  • 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