Unable to protect SQL DB from System Center Data Protection Manager 2010

Symptoms

While trying to create a protection group for a SQL database in System Center Data Protection Manager 2007 or System Center Data Protection Manager 2010, you may receive the following error:

DPM is unable to enumerate SqlServerWriter on computer ServerHostName.FQDN.COM (ID: 3055)

Cause

This problem occurs when the following conditions are true:
 
- The SQL server is in an untrusted domain or a workgroup.
- The SQL database is configured with mirroring.
- You are trying to protect a mirrored SQL database on the principle server.

Resolution

Protection of a mirrored SQL database in untrusted domains or workgroups, and even protection of a mirrored SQL database on a Principle server, is not supported by System Center Data Protection Manager 2007 or System Center Data Protection Manager 2010.  For more supportability information about SQL protection please see the following:

Managing Protected Computers in Workgroups and Untrusted Domains : http://technet.microsoft.com/en-us/library/ff634170.aspx
Properties

Article ID: 2691955 - Last Review: Mar 26, 2012 - Revision: 1

Feedback