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
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2691955 - Last Review: 03/26/2012 17:30:00 - Revision: 1.0

Microsoft System Center Data Protection Manager 2010, Microsoft System Center Data Protection Manager 2007 Service Pack 1, Microsoft System Center Data Protection Manager 2007

  • KB2691955
Feedback