• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

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.
0
michaelheffernan
Asked:
michaelheffernan
  • 4
  • 2
1 Solution
 
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now