DPM 2012 fails to backup SQL 2012 database

I was planning to protect remote SQL 2012 server from DPM 2012 server and encountered the below mention error,

SQL 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,

  1. In SQL Management Studio, connect to the SQL 2012 Server and then expand Security.
  2. Expand Logins and right click on NT AUTHORITY\SYSTEM and select Properties.
  3. Click Server Roles, check sysadmin and click OK.

SQLconsole 

 

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s