Maintenance Plans have no server access

All my maintenance plans on this server are reporting: "The job failed.  The owner () of job Transaction Log Backup Job for DB Maintenance Plan 'Maintainence reviewboard' does not have server access".  I cannot figure out how to give them access.  There was a domain administrator password change recently; this could be related.
michaelheffernanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

biscuit3Commented:
it sounds like the domain administrator password being changed is the root of your problem.  You will need to go through all your maintenance plans and determine what account they are running under and probably will have to change the password to the new domain administrator password.

I would highly recommend not using the domain administrator account for these maintenance jobs.  You should create new service accounts...(svc-DBMaint) give that account the minimum permissions to do it's job, set a complex password and document it for password update.  This way you can easily change the domain administrator's password in the future.  


0
michaelheffernanAuthor Commented:
That is part of my problem; I am unable to determine what account these plans are running under.  This info doesn't appear anywhere under "Properties".  Where should I be looking for this?
0
michaelheffernanAuthor Commented:
Ah, I created the job not as "sa" but as domain/admin.  It works now...
Thanks.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

michaelheffernanAuthor Commented:
BUT, where can I find who actually owns these jobs?  I see the column in sysjobs table, but no where in the gui....
0
biscuit3Commented:
it sounds like the SA account owns the jobs.
0
michaelheffernanAuthor Commented:
Resolution turned out to be permissions on the destination folder.  Backups run but still cannot get transaction logs to backup as a job.  As far as I can tell the job is "owned" by whoever is logged in (domain/admin in our case).  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.