Configuration Manager 2007 Installation Guide – Part 4

In Part 1 of this series we installed IIS.

In Part 2 we installed and configured WebDAV.

In Part 3 we installed BITS and Remote Differential Compression.

 

A ConfigMgr administrative group needs to be created and set up in the Active Directory before SQL Server can be installed.

SQL Server is a prerequisite of ConfigMgr. SQL Server is used by a ConfigMgr site server to store its site database.

This section will guide you through the creation process of a ConfigMgr administrator group and the installation and configuration of SQL Server 2008.

 

Creating a ConfigMgr Administrator Group

 

  1. Create a new user in Active Directory and name it sccmadmin and put a checkmark next to the Password never expires option.
  2. Go to Start>Administrative Tools and click Active Directory Users and Computers.
  3. Right-click on Global Groups in the Active Directory Users and Computers window, go to New in the context menu and click Group.
  4. In the New Object – Group window, type “GG SCCM Admins” as the group name, and then click OK.

 

Add the sccmadmin user to the GG SCCM Admins group

 

  1. Double-click on the GG SCCM Admins group.
  2. Click the Members tab in the GG SCCM Admins Properties window.
  3. Click the Add button and enter the sccmadmin user ID and click on Check Names.
  4. Click OK.
  5. Click on Apply in the GG SCCM Admins Properties window, and then click OK.
  6. Close the Active Directory Users and Computers window.
  7. Log into the ConfigMgr server using an account with administrative privileges.
  8. Add the sccmadmin user account to the local Administrators group.

 

Installing Microsoft SQL Server 2008

 

  1. Log into the ConfigMgr server using an account with administrative privileges.
    NOTE: SQL 2008 can be installed on a separate server instead if required.
  2. If running Windows Server 2008 R2, install the Application Server role before proceeding.
  3. Create the following user accounts in Active Directory: SQLAgent, SQLReporting, and SQLService.
    NOTE: When creating each account, verify that User must change password at next login is unchecked and verify that both User cannot change password and Password never expires are both checked.
  4. Insert the Microsoft SQL Server 2008 DVD into the DVD ROM drive.
  5. Run the Setup.exe from the Autorun or by browsing to the root of the DVD.
  6. If prompted, click OK to install the prerequisites. Complete all of the wizards for the prerequisite installs.

  1. In the SQL Server Installation Center window click on Installation.
  2. On the Installation page of the SQL Server Installation Center window click on New SQL Server stand-alone installation or add features to an existing installation.
  3. In the SQL Server 2008 setup wizard on the Setup Support Rules page, verify that all of the tests passed, and then click OK.

  1. On the Product Key page, specify your product key, and then click Next.
  2. On the License Key page, if you accept the terms, select I accept the license terms, and then click Next.
  3. On the Setup Support Files page, click Install.
  4. Wait patiently for the setup support files to install.
  5. On the Setup Support Rules page, verify that none of the tests failed, and then click Next.
  6. On the Feature Selection page, select Database Engine Services, Full-Text Search, Reporting Services, Management Tools – Basic, and Management Tools – Complete, and then click Next.

  1. On the Instance Configuration page, select Default instance, and then click Next.

  1. On the Disk Space Requirements page, review the disk space required and then click Next.
  2. On the Server Configuration page, provide the SQLAgent account and password for the SQL Server Agent field, the SQLService account and password for the SQL Server Database Engine field, and the SQLReporting account and password for the SQL Server Reporting Services field, and then click Next.

  1. On the Database Engine Configuration page, make sure Windows authentication mode is selected, and then click the Add button and provide the GG SCCM Admins group that we created earlier.

  1. Click on the Data Directories tab on the Database Engine Configuration page and change the drive letters to the drive letters appropriate for your installation, and then click Next.
  2. On the Reporting Services Configuration page, make sure that Install, but do not configure the report server is selected, and then click Next.

  1. On the Error and Usage Reporting page, click Next.
  2. On the Installation Rules page, verify that none of the tests failed, and then click Next.

  1. On the Ready to Install page, click Install.
  2. Wait patiently for SQL Server 2008 to finish installing. The process may take several minutes.
  3. On the Installation Progress page, verify that all of the components installed successfully, and then click Next.

  1. On the Complete page, click Close.

  1. Close the SQL Server Installation Center.
  2. Reboot the server.

 

Next in Part 5: Extending the Active Directory Schema