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

Published Feb 15 2019 10:59 AM 42 Views
First published on TECHNET on Mar 26, 2012

Here’s a new Knowledge Base article we published today. This one tells you how to fix and issue were you get error 3055 trying to create a protection group for a SQL database in DPM 2007 or DPM 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

=====

For the most current version of this article please see the following:

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

J.C. Hornbeck | System Center & Security Knowledge Engineer

Get the latest System Center news on Facebook and Twitter :

App-V Team blog: http://blogs.technet.com/appv/
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/

%3CLINGO-SUB%20id%3D%22lingo-sub-345045%22%20slang%3D%22en-US%22%3EKB%3A%20Unable%20to%20protect%20SQL%20DB%20from%20System%20Center%20Data%20Protection%20Manager%202010%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345045%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Mar%2026%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F78379iCBE3E1055E4D3687%22%20%2F%3E%20Here%E2%80%99s%20a%20new%20Knowledge%20Base%20article%20we%20published%20today.%20This%20one%20tells%20you%20how%20to%20fix%20and%20issue%20were%20you%20get%20error%203055%20trying%20to%20create%20a%20protection%20group%20for%20a%20SQL%20database%20in%20DPM%202007%20or%20DPM%202010%3A%3C%2FP%3E%0A%20%20%3CP%3E%3D%3D%3D%3D%3D%3C%2FP%3ESymptoms%3CP%3EWhile%20trying%20to%20create%20a%20protection%20group%20for%20a%20SQL%20database%20in%20System%20Center%20Data%20Protection%20Manager%202007%20or%20System%20Center%20Data%20Protection%20Manager%202010%2C%20you%20may%20receive%20the%20following%20error%3A%20%3CBR%20%2F%3E%20%3CSTRONG%3E%20DPM%20is%20unable%20to%20enumerate%20SqlServerWriter%20on%20computer%20ServerHostName.FQDN.COM%20(ID%3A%203055)%3C%2FSTRONG%3E%3C%2FP%3ECause%3CP%3EThis%20problem%20occurs%20when%20the%20following%20conditions%20are%20true%3A%3C%2FP%3E%0A%20%20%3CP%3E-%20The%20SQL%20server%20is%20in%20an%20untrusted%20domain%20or%20a%20workgroup.%3C%2FP%3E%0A%20%20%3CP%3E-%20The%20SQL%20database%20is%20configured%20with%20mirroring.%3C%2FP%3E%0A%20%20%3CP%3E-%20You%20are%20trying%20to%20protect%20a%20mirrored%20SQL%20database%20on%20the%20principle%20server.%3C%2FP%3EResolution%3CP%3EProtection%20of%20a%20mirrored%20SQL%20database%20in%20untrusted%20domains%20or%20workgroups%2C%20and%20even%20protection%20of%20a%20mirrored%20SQL%20database%20on%20a%20Principle%20server%2C%20is%20not%20supported%20by%20System%20Center%20Data%20Protection%20Manager%202007%20or%20System%20Center%20Data%20Protection%20Manager%202010.%20For%20more%20supportability%20information%20about%20SQL%20protection%20please%20see%20the%20following%3A%3C%2FP%3E%0A%20%20%3CP%3E%3CEM%3E%20Managing%20Protected%20Computers%20in%20Workgroups%20and%20Untrusted%20Domains%20%3C%2FEM%3E%20%3A%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fff634170.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fff634170.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3D%3D%3D%3D%3D%3C%2FP%3E%0A%20%20%3CP%3EFor%20the%20most%20current%20version%20of%20this%20article%20please%20see%20the%20following%3A%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2691955%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%202691955%20%3A%20Unable%20to%20protect%20SQL%20DB%20from%20System%20Center%20Data%20Protection%20Manager%202010%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CB%3EJ.C.%20Hornbeck%20%3C%2FB%3E%20%3CSTRONG%3E%20%7C%20System%20Center%20%26amp%3B%20Security%20Knowledge%20Engineer%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CB%3E%20Get%20the%20latest%20System%20Center%20news%20on%20%3C%2FB%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fpages%2FMicrosoft-System-Center-Support%2F111513322193410%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CB%3E%20Facebook%20%3C%2FB%3E%20%3C%2FA%3E%20%3CB%3E%20and%20%3C%2FB%3E%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2F%23!%2FMS_SystemCenter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20%3CB%3E%20Twitter%20%3C%2FB%3E%20%3C%2FA%3E%20%3CB%3E%20%3A%20%3C%2FB%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F78380i6ADFDF25FAC51FE6%22%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F78381iA4F3F0249195F31B%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EApp-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fappv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fappv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20ConfigMgr%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fconfigurationmgr%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20DPM%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fdpm%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20MED-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmedv%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Orchestrator%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Forchestrator%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Operations%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fmomteam%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20SCVMM%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fscvmm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fscvmm%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Server%20App-V%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fserverappv%20%3C%2FA%3E%20%3CBR%20%2F%3E%20Service%20Manager%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fservicemanager%20%3C%2FA%3E%20%3CBR%20%2F%3E%20System%20Center%20Essentials%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenteressentials%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fsystemcenteressentials%20%3C%2FA%3E%20%3CBR%20%2F%3E%20WSUS%20Support%20Team%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fsus%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fsus%2F%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3EThe%20Forefront%20Server%20Protection%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Ffss%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Ffss%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20Endpoint%20Security%20blog%20%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fclientsecurity%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20Identity%20Manager%20blog%20%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fms-identity-support%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20TMG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fisablog%2F%20%3C%2FA%3E%20%3CBR%20%2F%3E%20The%20Forefront%20UAG%20blog%3A%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.technet.com%2Fb%2Fedgeaccessblog%2F%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-345045%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Mar%2026%2C%202012%20Here%E2%80%99s%20a%20new%20Knowledge%20Base%20article%20we%20published%20today.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-345045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESystem%20Center%20Data%20Protection%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 11 2019 09:10 AM
Updated by: