DPM 2012 SP1 Backing up SQL 2012 Database Error

I migrated SharePoint to a new server with SQL 2012 SP1 and setup backups with DPM.

The initial setup went fine as DPM could see the Farm, however after the protection group was setup the backups failed immediately with the following error:

  • Unable to Configure Protection

Not a problem, what I have seen from documents seems like a bug in DPM 2012 trying to backup SQL 2012.

To fix this, open up SQL Management Studio, Navigate to Security, expand logins and locate the following account:

  • NT AuthoritySYSTEM

Right click on this account and select properties. Go to server roles and tick “sysadmin”. Apply these changes. Now go back to DPM and do a consistency check. It should now backup the databases.

If that fails, delete the protection group and create it again.

Hope it helps

Views All Time
Views All Time
Views Today
Views Today
Advertisements

Leave a Reply

Your email address will not be published. Required fields are marked *