Backup Scheduling error

• Kirty

  SSC Enthusiast

  Points: 175

  More actions

  July 2, 2003 at 4:19 am

  #159344

  After scheduling backup for database,when i start that job it gives me following error.

  gives error job failed..unable to determine if the owner of job testdb backup has server access (reason could not obtain information about windows nt group/user[sqlstate 42000]

  (error 81980)

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 2, 2003 at 4:42 am

  #463893

  In Enterprise Manager try editing the job properties and changing the owner to sa.

  
  Cheers,
  - Mark