Manually Install SQL Server 2005

  • Article

Applies To: Data Protection Manager, System Center Data Protection Manager 2007

This topic contains procedures for installing the following for DPM:

  • A dedicated instance (MS$DPM2007$) of Microsoft SQL Server 2005

  • Any remote instance of SQL Server 2005

Installing SQL Server 2005

To install SQL Server 2005 Standard or Enterprise Editions, you can run Setup using the SQL Server 2005 Installation Wizard or you can install it from the command prompt. You can also add components to an instance of SQL Server 2005 or upgrade to SQL Server 2005 from a previous version of SQL Server.

Installing a dedicated instance of SQL Server 2005

If you are using the MS$DPM2007$ instance of SQL Server 2005, you select the SYSTEM account for everything other than the Reporting Services. Select the Network service for the Reporting Services.

If you do not want to use the dedicated instance for DPM, you can use another instance name or you can install SQL Server on a different computer. For the procedures on how to install SQL Server on a remote computer, see Installing SQL Server on a Remote Instance.

To manually install a dedicated instance of SQL Server 2005

  1. Insert the Microsoft Data Protection Manager 2007 product DVD in the DVD drive.

  2. In Windows Explorer, browse to <DVD drive>:\SQLSVR2005\Servers, and then run setup.exe.

  3. On the Microsoft SQL Server 2005 End User License Agreement page, review the license agreement. If you accept the terms, click I accept the licensing terms and conditions, and then click Next.

  4. On the Installing Prerequisites page, click Install to install the software that SQL Server requires, and then click Next. The Microsoft SQL Server 2005 Setup Wizard starts.

  5. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.

  6. On the System Configuration Check page, verify that the configuration is successful, and then click Next.

  7. On the Registration Information page, type your registration information, and then click Next.

  8. On the Components to Install page, click Advanced.

  9. On the Feature Selection page, select the following features:

    • Database Services.

      Expand the Database Services feature, and then select Data Files. Verify that Shared Tools is also selected.

    • Reporting Services.

      Select Entire feature will be installed on local hard drive.

    • Client Components.

      Expand the Client Components feature, and then select Management Tools.

  10. Click Next.

  11. On the Instance Name page, select Named instance, type MS$DPM2007$, and then click Next.

  12. On the Service Account page, do the following:

    1. Select Customize for each service account.

    2. In the Service box, select SQL Server.

    3. Select Use the built-in System account, then select Local System account.

    4. In the Service box, select SQL Server Agent.

    5. Select Use the built-in System account, then select Local System account.

    6. In the Service box, select Reporting Services.

    7. Select Use the built-in System account, and then select the Network service account.

    8. In the Service box, select SQL Browser.

    9. Select Use the built-in System account, then select Local Service account.

  13. Click Next.

  14. Follow the SQL Server wizard instructions on the remaining pages, and accept all default settings.

  15. On the Ready to Install page, click Install to begin the installation.

After you have completed the installation, verify that SQL Server 2005 is running.

Installing SQL Server 2005 on a Remote Instance

When using the remote instance of SQL Server, we recommend that you use the following settings:

  • Use the default failure audit setting.

  • Use the default Windows Authentication mode.

  • Assign a strong password to the sa account.

  • Enable password policy checking.

  • Install only the SQL Server Database Engine and Reporting Services components.

  • Use the least-privileged user account on the computer running SQL Server.

If you are installing SQL Server on a remote computer, choose a domain user account for all services. Reporting services can be run as a Network service.

Warning

To access an instance of SQL Server through a firewall, you must configure the computer that is running SQL Server to use port 80.

To manually install a remote instance of SQL Server 2005

  1. Insert the Microsoft Data Protection Manager 2007 product DVD in the DVD drive.

  2. In Windows Explorer, browse to <DVD drive>:\SQLSVR2005\Servers, and then run setup.exe.

  3. On the Microsoft SQL Server 2005 End User License Agreement page, review the license agreement. If you accept the terms, click I accept the licensing terms and conditions, and then click Next.

  4. On the Installing Prerequisites page, click Install to install the software that SQL Server requires, and then click Next. The Microsoft SQL Server 2005 Setup Wizard starts.

  5. On the Welcome to the Microsoft SQL Server Installation Wizard page, click Next.

  6. On the System Configuration Check page, verify that the configuration is successful, and then click Next.

  7. On the Registration Information page, type your registration information, and then click Next.

  8. On the Components to Install page, click Advanced.

  9. On the Feature Selection page, select the following features:

    • Database Services.

      Expand the Database Services feature, and then select Data Files. Verify that Shared Tools is also selected.

    • Reporting Services.

      Select Entire feature will be installed on local hard drive.

  10. Click Next.

  11. On the Instance Name page, select Named instance, and use the remote SQL Server instance name.

    Note

    DPM supports pointing two DPM servers to two different instances of SQL Server on the same computer.

  12. On the Service Account page, do the following:

    1. Select Customize for each service account.

    2. In the Service box, select SQL Server.

      Note

      We recommend that you run the SQL Server computer under a domain user account. You would in this case, provide the details of the Domain User account.

    3. Select Use the built-in System account, and then if you want to run the SQL Server computer under a local system account, select the Local System account.

    4. In the Service box, select SQL Server Agent.

      Note

      We recommend that you run the SQL Server agent computer under a domain user account. You would in this case, provide the details of the Domain User account.

    5. Select Use the built-in System account, and then if you want to run the SQL Server agent under a local system account, select the Local System account.

    6. In the Service box, select Reporting Services.

    7. Select Use the built-in System account, and then select the Network service account.

  13. Click Next.

  14. Follow the SQL Server wizard instructions on the remaining pages, and accept all default settings.

  15. On the Ready to Install page, click Install to begin the installation.

After you have completed the installation, verify that SQL Server 2005 is running.

Verifying that SQL Server 2005 is running

Before you can install DPM 2007, the instance of SQL Server 2005 must be running.

To verify that SQL Server 2005 is running

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, verify that the instance of SQL Server service is running.

See Also

Concepts

Hardware Requirements
Network Requirements
Security Requirements

Other Resources

Software Prerequisites