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

Article ID: 2691955 - View products that this article applies to.
Expand all | Collapse all

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: March 26, 2012 - Revision: 1.0
APPLIES TO
  • Microsoft System Center Data Protection Manager 2010
  • Microsoft System Center Data Protection Manager 2007 Service Pack 1
  • Microsoft System Center Data Protection Manager 2007
Keywords: 
KB2691955

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com