locked
dpm 2016 jobs not running even though no errors RRS feed

  • Question

  • I thought everyhting was fine with my dpm 2016 installation since there were not warnings in dashboard, then i notice i had no new recovery points since initial backup.  finally in even viewer i found sql errors saying 

    SQL Server Scheduled Job '4c6f1d88-077a-40b2-b527-8632de861bcf' (0x3A5621EF953D3E40B10E1786ADE69770) - Status: Failed - Invoked on: 2017-06-19 13:30:00 - Message: The job failed.  The owner (MICROSOFT$DPM$Acct) of job 4c6f1d88-077a-40b2-b527-8632de861bcf does not have server access.  

    So i went in and added the user to the database with read and write roles but now the jobs are failing with this in the event viewer.

    SQL Server Scheduled Job 'd11fee45-afba-4021-939f-d431a1f87340' (0x202D66695545804FB853B8E61B05CBC3) - Status: Failed - Invoked on: 2017-06-19 14:00:00 - Message: The job failed.  The Job was invoked by Schedule 222 (Schedule 1).  The last step to run was step 1 (Default JobStep).

     I am not good with sql and cant find any good info that seems to work please help.

    Tuesday, June 20, 2017 7:44 PM

Answers

All replies