Uncategorized

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

Image

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)”

Image

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.

https://i0.wp.com/lyncme.co.uk/wp-content/uploads/2013/08/DPM-2012-SQL-Replication-1.png

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.

References:

DPM: Unable to Configure Protection on SQL 2012 Database

http://scug.be/scdpm/2013/01/19/unable-to-configure-protection-with-sql-server-2012/

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