While trying to create a protection group in System Center Data Protection Manager 2007 SP1 or System Center Data Protection Manager 2010, you may receive the following error:
DPM cannot protect your Windows SharePoint services farm until you install agents on the following server ServerHostName.FQDN.COM ID 956
This error message can be caused by an improperly configured SQL alias.
To properly configure SQL aliasing setup both 64-bit and 32-bit aliases:
64-bit SQL alias configuration
Start cliconfg.exe from each WFE server in the farm.
Navigate to the Alias tab.
Enter the name of the alias in the "Server Alias:" window.
Enter the Fully Qualified Domain Name of the SQL server in "Server Name:" under Connection parameters.
Check the radio button for TCP/IP in the Network Libraries section.
32-bit SQL alias configuration
On all WFE servers, open SQL Server Configuration Manager (installation of SQL Server Configuration Manager is required unless it already exists. For SharePoint 2007, install SQL 2005 Client Tools Connectivity. For SharePoint 2010, install SQL 2008 Client Tools Connectivity).
From the SQL Server Configuration Manager, expand the SQL Native Client 10.0 Configuration (32bit) and click on the Aliases.
In the right panel, right click and select New Alias…
For the Alias Name, enter the name of the alias being used.
For the Server, enter the Fully Qualified Domain Name of the server to which the alias will resolve.
SQL Aliasing allows SharePoint administrators to move SharePoint Databases between SQL servers if the need arises. The Administrator can do this by creating a new SQL alias on all servers in the farm using cliconfg.exe or SQL Server Configuration Manager.