Installing DPM Using a Local Instance of SQL Server 2008

Applies To: System Center Data Protection Manager 2010

System Center Data Protection Manager (DPM) 2010 requires a SQL Server 2008 SP1 instance for the DPM database. During setup, you can choose to have DPM Setup install a dedicated SQL Server instance on the DPM server, or you can specify a remote SQL Server instance.

This topic explains how to install DPM when you want to use a dedicated SQL Server 2008 SP1 instance on the DPM server.


DPM Setup automatically installs a number of software prerequisites if they are not already installed or enabled. For a list of the prerequisites, see DPM Server Software Prerequisites.

If any of the prerequisites do not install automatically during setup, you can install them manually. For more information, see Manually Installing Prerequisite Software.

To install DPM using a local SQL Server instance

  1. Log on to the computer that will be your DPM server using a domain user account that is a member of the local Administrators group.

  2. Insert the DPM product DVD in the DVD-ROM drive. If the DPM Setup Wizard does not start automatically, double-click setup.exe in the root folder of the DVD.


    If you are installing DPM from a network share, navigate to the installation share, and then double-click setup.exe in the root folder of the share.


    If you use a network share to install DPM, you should apply the appropriate security to the share to ensure that no unauthorized or unauthenticated users can access or alter the contents of the share.

  3. On the Microsoft System Center Data Protection Manager 2010 screen, click Install Data Protection Manager.

  4. On the Microsoft Software License Terms page, review the license agreement. If you accept the terms, click I accept the license terms and conditions, and then click OK.


    You can copy and paste the license agreement into a text editor, such as Notepad, for printing. After installation is complete, you can access the license agreement from DPM Administrator Console by clicking the product information icon on the navigation bar.

    After you click OK, DPM installs the Visual C++ Redistributable 2008 package and Microsoft .NET Framework 3.5 SP1 if they have not already been installed, and the Data Protection Manager Setup Wizard opens.

  5. On the Welcome page, click Next.

    DPM begins a prerequisites check for all required hardware and software.

  6. On the Prerequisites Check page, wait while Setup checks the system to verify that it meets software and hardware requirements, and then do one of the following:

    • If all required components are present, Setup displays a confirmation. Click Next to continue installing DPM.

    • If one or more prerequisites are missing or noncompliant, Setup displays warnings or error messages. Click Next to proceed to the Prerequisites Installation page.

      On the Prerequisites Installation page, do one of the following:

      • Click Install to install missing prerequisites that do not require a restart and continue installing DPM.

      • Click Restart and then click OK to install missing prerequisites that require a restart. After the computer has restarted, run DPM Setup again.

  7. On the Product Registration page, enter a user name, company name, and a valid product key, and then in n the Protection agent licenses area do the following:

    1. In the Standard licenses box, type the number of licenses that you have purchased to authorize protection of file resources and system state.

    2. In the Enterprise licenses box, type the number of licenses that you have purchased to authorize protection of both file and application resources.

    3. In the Client licenses box, type the number of licenses that you have purchased to authorize protection of client computers (laptops and desktops).


    If you purchase additional licenses after you set up DPM or reallocate licenses from one DPM server to another, you can update the number of available licenses for each DPM server in DPM Administrator Console. For information about updating your protection agent licenses, in DPM 2010 Help, see How to Update DPM License Information (

  8. On the Installation Settings page, do the following:

    • In the DPM Program Files section, accept the default installation folder or click Change to browse to the folder to which you want to install DPM.

      If you change the default installation folder, note the following requirements and recommendations:

      • You can install DPM only on a local drive, and you cannot install it in read-only folders, hidden folders, or directly to local Windows folders such as Documents and Settings or Program Files. However, you can install DPM to a subfolder of the Program Files folder.

      • The installation partition must be formatted with the NTFS file system.

      • To simplify recovery in the event of a system partition failure, install DPM to a partition that is separate from the system partition.

    • In the SQL server settings section, click Use an existing instance of SQL Server 2008, and then click Next.

  9. On the Security Settings page, specify and confirm a strong password for the restricted MICROSOFT$DPM$Acct and DPMR*$<computer name>* local user accounts, and then click Next.

    To enhance security, DPM Setup creates the following low-privileged local user accounts:

    • MICROSOFT$DPM$Acct to run the SQL Server and SQL Server Agent services.

    • DPMR$<computer name> to generate DPM reports by using SQL Server Reporting Services.

    A strong password is typically defined as a password that is at least six characters long, does not contain all or part of the user’s account name, and contains at least three of the following four categories of characters: uppercase characters, lowercase characters, base 10 digits, and symbols (such as !, @, #).


    The password that you specify for these accounts does not expire.

  10. On the Microsoft Update Opt-In page, specify if you want to sign up for the Microsoft Update service, and then click Next.

    After you install DPM, you can change your Microsoft Update settings in Control Panel at any time. For more information, see the Microsoft Update Web site (


    If you have previously chosen to use Microsoft Update on this computer, the Microsoft Update page does not appear.

  11. On the Customer Experience Improvement Program page, specify if you want to enlist in the Customer Experience Improvement Program (CEIP), and then click Next.

    You can change your CEIP settings at any time by using DPM Administrator Console. In the Selected Items area of any task area, click Options, click the Customer Feedback tab, and then select an option.

  12. On the Summary of Settings page, review the summary of installation settings. To install DPM using the specified settings, click Install. To change any setting, click Back.

    After the installation is complete, the Installation page displays the installation status.

  13. Click Close, and then restart the computer to incorporate all of the changes made by DPM Setup.


A restart is necessary to start the volume filter that DPM uses to track and transfer block-level changes between DPM and the computers it protects, or between the primary and secondary DPM servers.

After you install DPM, you must perform some required configuration tasks before you can start protecting your data. For more information, see Required Configuration Tasks.

See Also


Installing DPM Using a Remote Instance of SQL Server 2008

Other Resources

Installing DPM 2010
DPM 2010 System Requirements