DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2543859 - Last Review: September 12, 2011 - Revision: 2.0

SUMMARY

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
  1. Start cliconfg.exe from each WFE server in the farm.
  2. Navigate to the Alias tab.
  3. Click Add...
  4. Enter the name of the alias in the "Server Alias:" window.
  5. Enter the Fully Qualified Domain Name of the SQL server in "Server Name:" under Connection parameters.
  6. Check the radio button for TCP/IP in the Network Libraries section.
  7. Click OK.
32-bit SQL alias configuration

  1. 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).
  2. From the SQL Server Configuration Manager, expand the SQL Native Client 10.0 Configuration (32bit) and click on the Aliases.
  3. In the right panel, right click and select New Alias…
  4. For the Alias Name, enter the name of the alias being used.
  5. For the Server, enter the Fully Qualified Domain Name of the server to which the alias will resolve.


MORE INFORMATION

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.
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.

APPLIES TO
  • Microsoft System Center Data Protection Manager 2010
  • Microsoft System Center Data Protection Manager 2007 Service Pack 1
Keywords: 
KB2543859
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support