System Center Data Protection Manager (DPM) 2010 requires SQL Server 2008 (SP1), Standard or Enterprise Edition, 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
Before you install DPM, you must install a new, dedicated instance of SQL Server 2008. 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 will 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 cannot be on
a computer that is running as a domain controller.
- A remote instance of SQL Server must be
running SQL Server 2008 with Service Pack 1 (SP1)
Standard or Enterprise Edition.
- The computer running 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. DPM
administrators must be added to these groups 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
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.
- Assign a strong password to the sa
- Enable password policy checking.