Export (0) Print
Expand All

Plan for the DPM SQL Server database

Updated: November 1, 2013

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

A System Center 2012 - Data Protection Manager (DPM) deployment requires an instance of SQL Server to host the DPM database. DPM in System Center 2012 can use the following versions of SQL Server:

  • SQL Server 2012

  • SQL Server 2008 R2 with SP1

  • SQL Server 2008 R2

When you select a SQL Server during DPM installation, you can use either of the following:

  • A existing local instance of SQL Server installed on the computer on which you are installing DPM—If you select to use a local instance during DPM Setup, a DPM account that does not expire will be created to run the required SQL Server and SQL Server Agent accounts.

  • A remote instance of SQL Server—If you want to use a remote instance, note the following:

    • The server running SQL Server and the DPM server should be located in the same domain.

    • The remote instance of SQL should not be running on a domain controller.

    • The remote instance of SQL Server should be running the following components only:

      • SQL Server Database Engine

      • Reporting Services

    • The remote instance of SQL Server should not run as Local System.

    • Use the following SQL Server settings: default failure audit; enable password policy checking; default Windows Authentication mode.

    • Run SQL Server using a low-privileged domain user account.

    • For the DPM server to access a remote instance of SQL Server through Windows Firewall, on the remote computer, you must configure an incoming exception for sqlservr.exe for the specific instance that you use for the DPM database to allow use of the TCP protocol on port 80.

    • After the installation of SQL Server is complete, enable the TCP/IP protocol for the specific instance that you use for the DPM database.

After installation, your DPM database will be named DPMDB_<DPMServername> or DPMDB_<DPMServername><GUID>.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft