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 Authority\SYSTEM
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