Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL maintenance plans with 'Run as' user deleted from AD Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2014 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 4:06 PM
Points: 5, Visits: 9
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!
Post #1577387
Posted Wednesday, June 4, 2014 9:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 271, Visits: 1,108
Have you tried changing the associated Jobs owner to 'sa'?
Post #1577390
Posted Wednesday, June 4, 2014 9:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 9:55 AM
Points: 1,288, Visits: 1,863
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
Post #1577391
Posted Wednesday, June 4, 2014 9:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 4:06 PM
Points: 5, Visits: 9
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'

...?
Post #1577395
Posted Wednesday, June 4, 2014 11:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 9:55 AM
Points: 1,288, Visits: 1,863
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
Post #1577449
Posted Wednesday, June 4, 2014 1:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 4:06 PM
Points: 5, Visits: 9
Microsoft SQL Server Management Studio 9.00.4035.00
Microsoft Analysis Services Client Tools 2005.090.4035.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.3655
Operating System 5.2.3790
Post #1577516
Posted Wednesday, June 4, 2014 2:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 271, Visits: 1,108
At this point, I would just delete those existing 3 Maintenance plans and recreate them from scratch.
Post #1577543
Posted Wednesday, June 4, 2014 2:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 4:06 PM
Points: 5, Visits: 9
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.
Post #1577558
Posted Wednesday, June 4, 2014 3:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 4:06 PM
Points: 5, Visits: 9
PS

is there a way of comparing the two tasks, old versus newly created? I'm not sure I ~cloned~ them exactly.
Post #1577580
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse