Help: Backups Can't Run

• Tad

  Say Hey Kid

  Points: 701

  More actions

  January 21, 2003 at 8:31 am

  #158541

  Help: Our network administrator reboot the SQL Server and now the maintenance plans give the following error.

  The job failed. The owner () of job Optimizations Job for DB Maintenance Plan 'HazWebPublic' does not have server access.

  The owner of the job is a member of domain admins. The group domain admins is in the local administrator group.

  All SQL Server services are started with a Domain User account, SQLService, that is also in the local administrator group.

  Thanks

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  January 21, 2003 at 11:29 am

  #446886

  Did you add the account SQLService to the Services on the server yourself or was it done through the Enterprise Manager?

  SQL needs some access to the registry for the backups and the rights might not be set up correctly if you did it yourself.

  See http://support.microsoft.com/default.aspx?scid=kb;en-us;283811 for some help in checking.

  Been there, done that,

  Michelle

  
  
  Michelle