Remote SQL Server Requirements

  • Article

Applies To: System Center Data Protection Manager 2010

System Center Data Protection Manager (DPM) 2010 requires SQL Server 2008 (SP1), Standard or Enterprise Edition, 64-bit or 32-bit version, for the DPM database.

System requirements for a remote SQL Server instance are the same as those that SQL Server recommends. For more information about SQL Server requirements, see Hardware and Software Requirements for Installing SQL Server 2008 (https://go.microsoft.com/fwlink/?LinkId=150629).

Note

On the computer where SQL Server is installed, you must install the following update:

Security Update for Microsoft Office 2003 Web Components for the 2007 Microsoft Office System (KB947318) (https://go.microsoft.com/fwlink/?LinkId=187331).

Before you install DPM, you must install a new, dedicated instance of SQL Server 2008 SP1. For step-by-step instructions for installing a remote instance of SQL Server for use with DPM, see Installing DPM Using a Remote Instance of SQL Server 2008.

Note that if you are installing SQL Server on Windows Server 2008 R2, a compatibility warning might appear. Select Run program, and then proceed with the SQL Server 2008 installation. For more information, see Installing DPM Using a Remote Instance of SQL Server 2008.

When you use a remote instance of SQL Server for DPM, note the following:

  • A remote instance of SQL Server on a domain controller is not supported unless DPM is also installed on the domain controller. For information about installing DPM on a domain controller, see Installing DPM on a Domain Controller.

  • A computer running a remote instance of SQL Server must be located in the same domain as the DPM server.

  • DPM Setup creates the DPMDBReaders$<DPM server name>** and DPMDBAdministrators$<DPM server name> local groups on the remote instance of SQL Server. You must add DPM administrators to these groups for DPM to use the remote instance of SQL Server.

  • For the DPM server to access a remote SQL Server instance through Windows Firewall on the remote computer, you must configure an exception for SQLServer.exe to use port 80.

When installing a new remote instance of SQL Server for use with DPM, we recommend that you use the following SQL Server settings:

  • Use the default failure audit setting.

  • If you use domain accounts to run the SQL Server Agent and SQL Server Reporting Services services, in SQL Server Configuration Manager, expand SQL Server Network Configuration, and then enable the Named Pipes protocol for the DPM database.

  • Enable password policy checking.

See Also

Concepts

Installing DPM Using a Remote Instance of SQL Server 2008

Other Resources

Software Requirements