Step 1-9: Install SQL Server 2008 R2

Before installing Configuration Manager 2012, install SQL Server 2008 R2 SP1 and CU4.

Note To enable all SQL Server 2008 R2 features, install the Web Services (IIS) server role before installing SQL Server 2008 R2.

To install SQL Server 2008 R2

1. Start the SQL Server Installation Center.

2. In the SQL Server Installation Center, in the navigation pane, click Installation.

3. In the preview pane, click New installation or add features to an existing installation.

SQL Server 2008 R2 Setup Wizard starts.

4. Install SQL Server 2008 R2 using the information in Table 9, accepting the defaults unless otherwise specified.

Table 9. Information for Installing SQL Server 2008 R2

On this wizard page	Do this
Setup Support Rules	Click OK.
Product Key	Click Next.
License Terms	Select the I accept the license terms check box, and then click Next.
Setup Support Files	Click Install.
Setup Support Rules	Ensure that no critical results exist for the rules, and then click Next.
Setup Role	Click SQL Server Feature Installation, and then click Next.
Feature Selection	1. Select the Database Engine Services check box. 2. Select the Reporting Services check box. 3. Select the Full-Text Search check box. 4. Select the Management Tools - Complete check box. 5. Click Next.
Installation Rules	Click Next.
Instance Configuration	Click Next.
Disk Space Requirements	Click Next.
Server Configuration	1. For SQL Server Agent, in Account Name, type MDT2012\SQLAgent, in Password, type P@ssw0rd. 2. For SQL Server Database Engine, in Account Name, type MDT2012\SQLDBEngine, in Password, type P@ssw0rd. 3. For SQL Server Reporting Services, in Account Name, type MDT2012\SQLReport, in Password, type P@ssw0rd. 4. Click Next.
Database Engine Configuration	Click Add Current User, and then click Next.
Reporting Services Configuration	Click Next.
Error Reporting	Click Next.
Installation Configuration Rules	Click Next.
Ready to Install	Click Install.
Complete	Click Close.

5. Close the SQL Server Installation Center.

To install SQL Server 2008 R2 SP1

1. In Windows Explorer, go to E:\Source$\SQL2008R2SP1, and double-click SQLServer2008R2SP1-KB2528583-x64-ENU.exe.

The Extracting Files dialog box displays the file-extraction process. When the process is complete, the SQL Server 2008 R2 Service Pack 1 Update Setup Wizard starts.

2. Install SQL Server 2008 R2 SP1 using the information in Table 10, accepting the defaults unless otherwise specified.

Table 10. Information for Installing SQL Server 2008 R2 SP1

On this wizard page	Do this
SQL Server 2008 R2 update	Click Next.
License Terms	Select the I accept the license terms check box, and then click Next.
Select Features	Click Next.
Check Files In Use	Click Next.
Ready to update	Click Update.
Update Progress	The progress is displayed on the wizard page as the update is performed and finishes.
Complete	Click Close.

To install SQL Server 2008 R2 SP1 CU6

1. In Windows Explorer, go to E:\Source$\SQL2008R2SP1CU6, and double-click 446622_intl_x64_zip.exe.

The Microsoft Self-Extractor dialog box appears.

2. In the Microsoft Self-Extractor dialog box, click Continue.

3. In the Microsoft Self-Extractor dialog box, in Select the folder where you want to unzip the files to, type E:\Source$\SQL2008R2SP1CU6, and then click OK.

Note You can click the ellipse (…) to browse for the E:\Source$\SQL2008R2SP1CU6 folder.

The extraction process is displayed. When the process is complete, the completion status is displayed.

4. In the Microsoft Self-Extractor dialog box, click OK.

5. In Windows Explorer, go to E:\Source$\SQL2008R2SP1CU6, and double-click SQLServer2008R2- KB2679367-x64.exe.

The Extracting Files dialog box displays the file-extraction process. When the process is complete, the SQL Server 2008 R2 Service Pack 1 CU6 Update Setup Wizard starts.

6. Install SQL Server 2008 R2 SP1 CU6 using the information in Table 11, accepting the defaults unless otherwise specified.

Table 11. Information for Installing SQL Server 2008 R2 SP1 CU6

On this wizard page	Do this
SQL Server 2008 R2 update	Click Next.
License Terms	Select the I accept the license terms check box, and then click Next.
Select Features	Click Next.
Check Files In Use	Click Next.
Ready to update	Click Update.
Update Progress	The progress is displayed on the wizard page as the update is performed and finishes.
Complete	Click Close.

The Install a SQL Server 2008 R2 update dialog box appears prompting you to restart the computer to complete the setup.

7. In the Install a SQL Server 2008 R2 update dialog box, click OK.

8. Restart the computer.

9. After installing SQL Server 2008 R2 SP1 CU6, the SQL Server build number should be 10.51.2811.0.

Tip You can verify the SQL Server build number by viewing the SQL Server updates applied in the Programs and Features Control Panel item by clicking View installed updates.