Loading…

Andrew J. Price | Technical Blog

Office Servers and Services MVP | Founder of UC and Cloud Day | Founder of Microsoft Cloud User Group

DPM: Unable to Configure Protection on SQL 2012 Database

Hello Readers,

Having recently implemented Microsoft Data Protection Manager 2012 SP1 into my Lab Envirnoment, I have been experiencing issues protecting Microsoft SQL Server 2012 Databases as seen below

DPM 2012 - SQL Replication

It appears this is a known issue with DPM/SQL 2012 as Microsoft have released information within one of its press release. The statement says;

Do the following to protect the Microsoft SQL Server 2012 database:

Connect to the SQL Server 2012 instance through the Management Studio, and then select and expand Security. Select and expand Logins, right-click NT AUTHORITY\SYSTEM, and then click Properties. Click Serverroles, click sysadmin, and then click OK.

So as a test I have set “sysadmin” on my DPM instance as shown below

DPM 2012 - SQL Replication 1

And “Performed a Consistency Check” on the SQL Tables that failed in Data Protection Manager. SUCESS!! The tables are now showing as “OK” so the above step just needed to be completed on my Default SQL Instance.

DPM 2012 - SQL Replication 2

The release notes can be found that the following link

Release Notes for System Center 2012 – Data Protection Manager http://technet.microsoft.com/en-us/library/jj860415.aspx

6 thoughts on “DPM: Unable to Configure Protection on SQL 2012 Database

Leave a Reply