I was planning to protect remote SQL 2012 server from DPM 2012 server and encountered the below mention error,
The suggestion is to add “‘NT Service\DPMRA\ to the sysadmin role on the SQL Server instance.” The problem is I don’t have an ‘NT Service\DPMRA’ user in Windows or SQL on that remote SQL server when tried to add. To make the story short all you have to do is in the remote SQL server do as follows,
- In SQL Management Studio, connect to the SQL 2012 Server and then expand Security.
- Expand Logins and right click on NT AUTHORITY\SYSTEM and select Properties.
- Click Server Roles, check sysadmin and click OK.
After that run the consistency checkups on the DPM side and you’ll see the problem resolved 🙂
Edit: I found another article stating the same issue with different resolution approach.