DPM: Unable to Configure Protection on SQL 2012 Database

Today after configuring DPM 2012 R2 to protect SQL server 2012. i received the following error Unable to Configure Protection


and by reviewing the event viewer you  can find the following log: “The DPM job failed for SQL01\WSS_Content because the protection agent did not have sysadmin privileges on the SQL Server instance. (ID: 33424)”


You can solve this By:

1. Log on to the Microsoft SQL Server Management Studio

2. Connect to the correct instance

3. expand Security. Select and expand Logins, right-click NT AUTHORITY\SYSTEM, and then click Properties. Click Serverroles, click sysadmin, and then click OK.


Now go to the DPM server and right click on the SQL Tables and “Perform a Consistency Check” it will take about a minute then gives you the “OK” State.


DPM: Unable to Configure Protection on SQL 2012 Database



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