Select the product you need help with

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

Article ID: 2691955 - View products that this article applies to.

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)

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

Back to the top | Give Feedback

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

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback