You may receive the following error message when you try to create a protection group in a Microsoft SharePoint 2007 or Microsoft SharePoint 2010 farm by using Microsoft System Center Data Protection Manager 2007 or Microsoft System Center Data Protection Manager 2010:
DPM is unable to protect your Windows Sharepoint Service farm until you install agent on the following server: Computername.domainname of the WFE. ID 956.
This issue can occur when the following conditions are true:
You use a named instance for the configuration and content databases for SharePoint.
You use SQL Aliases in SharePoint to connect to Microsoft SQL Server.
You installed SharePoint and SQL Server on an x64-based operating system.
There can be multiple causes of this issue:
DPM is not using the correct hive to check SQL aliases.
SharePoint does not request the correct WMI namespace to provide information about SQL aliases.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
Check and set registry subkeys correctly. To do this, follow these steps:
Click Start, click Run, type regedit, and then click OK.
Locate and then click the following registry subkey:
For more information about how SQL uses the registry to handle the "ConnectTo" hive, see the following article:
936491 After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager
To correctly configure a SQL aliasing setup for both 64-bit and 32-bit aliases
64-bit SQL alias configuration
Start cliconfg.exe from each WFE server in the farm.
On the Alias tab, click Add.
In the Server Alias text box, enter the name of the alias that you want to add.
In the Server Name text box, under Connection parameters, enter the fully qualified domain name(FQDN) of the SQL Server.
In the Network Libraries section, click the TCP/IP option.
32-bit SQL alias configuration
On all WFE servers, open Microsoft SQL Server Configuration Manager.
Note The installation of SQL Server Configuration Manager is required unless it is already installed. For SharePoint 2007, install SQL 2005 Client Connectivity Tools. For SharePoint 2010, install SQL 2008 Client Connectivity Tools.
From the SQL Server Configuration Manager, expand SQL Native Client 10.0 Configuration (32bit), and then click Aliases.
In the panel on the right side, right-click and then select New Alias.
In the Alias Name field, enter the name of the alias that is being used.
In the Server field, enter the fully qualified domain name(FQDN) of the server to which the alias will resolve.
For more information about System Center Data Protection Manager, see the following article:
2543859 Unable to protect a SharePoint Farm with System Center Data Protection Manager 2010
SharePoint 2007 or 2010; Protected group; DPM 2007 or 2010; SQL aliasing