Error during item level recovery in DPM 2016 related to SQL Agent service account

All replies

• 

  

  0

  Sign in to vote

  Hi!

  Do you receive an error during the item level recovery before or after changing the SQL service account of the agent?

  Best regards,
  Leon

  ---

  Blog: https://thesystemcenterblog.com LinkedIn:

  Thursday, November 15, 2018 5:12 PM
• 

  

  0

  Sign in to vote

  Both.  That's the reason I changed the service account.

  Thursday, November 15, 2018 5:13 PM
• 

  

  0

  Sign in to vote

  Ok, where did you change the service account? The SQL service accounts needs to be changed in the SQL Server Configuration Manager, because it will grant the required permissions to run agent jobs for the domain account.

  Changing the SQL Server Agent service account

  1. Stop and then start the SQL Server Agent service.
  2. Set the domain account for the SQL Server Agent service in SQL Server Configuration Manager.
  3. Start the SQL Server Agent service.

  ---

  Blog: https://thesystemcenterblog.com LinkedIn:

  Thursday, November 15, 2018 5:18 PM
• 

  

  0

  Sign in to vote

  I did exactly that making sure the following permissions/SQL roles were in place:

  https://docs.microsoft.com/en-us/sql/ssms/agent/select-an-account-for-the-sql-server-agent-service?view=sql-server-2017

  Thursday, November 15, 2018 5:19 PM
• 

  

  0

  Sign in to vote

  What does your DPM log say?

  C:\Program Files\Microsoft Data Protection Manager\DPM\Temp\DPMCurr.errlog

  Check on both DPM and SharePoint servers.

  Edit: Has this worked previously? Has there been any change in the SharePoint environment or DPM environment?

  ---

  Blog: https://thesystemcenterblog.com LinkedIn:

  
  
  

  • Edited by Leon Laude Thursday, November 15, 2018 5:54 PM

  Thursday, November 15, 2018 5:27 PM