Install SQL Server 2008 R2 SP2 for ConfigMgr 2012 SP1

This blog post will cover the steps necessary to install SQL Server 2008 R2 SP2 running on Windows Server 2012.

Overview

• Install .NET Framework 3.5 with PowerShell
• Create Active Directory SQL service accounts
• Install SQL Server 2008 R2
• Install SQL Server 2008 R2 Service Pack 2

Install .NET Framework 3.5 with PowerShell

Open a Windows PowerShell prompt as an administrator, and run the following command:

Add-WindowsFeature NET-Framework-Core

Create Active Directory SQL service accounts

Create 3 service accounts in Active Directory. Name the accounts SQLAgent, SQLDB and SQLReport.

Install SQL Server 2008 R2

1. Mount the SQL Server 2008 R2 ISO to your server.
2. Launch the setup program and click on Installation in the left pane.

3. Click on New installation or add features to an existing installation.

4. Click OK in the Setup Support Rules window.

5. Click Install in the Setup Support Files window.

6. If you have the Windows Firewall enabled, you’ll see a warning about that. Dismiss the warning and click Next in the Setup Support Rules window.

7. Enter your product key and press Next in the Product Key window.

8. Accept the license terms and click Next in the License Terms window.

9. Select SQL Server Feature Installation and click Next in the Setup Role window.

10. Select Database Engine Services, Reporting Services, Management Tools – Basic and Management Tools – Complete and click Next in the Feature Selection window. Note, if you wish to install to another directory than specified at the bottom, select your appropiate location.

11. Click Next in the Installation Rules window when the operation has completed.

12. Select Default Instance, leave all values by their default and click Next in the Instance Configuration window. Note, if you choose a Named instance, remember to specify it later in the ConfigMgr 2012 SP1 installation wizard.

13. Click Next in the Disk Space Requirements window.

14. Enter the Account Name for each Service and click on the Collation tab in the Server Configuration window.

15. Click on Customize in the Server Configuration window.

16. Click on SQL collation, used for backwards compatability and scroll down and select SQL_Latin1_General_CP1_CI_AS. Click on OK and then Next in the Server Configuration window. Note, it’s really important that you choose the correct collation or the installation of ConfigMgr 2012 will not work.

17. Select Windows authentication mode and then click on Add Current User. Click Next in the Database Engine Configuration window.

18. Select Install the native mode default configuration and click Next in the Reporting Services Configuration window.

19. Click Next in the Error Reporting window.

20. Click Next in the Installation Configuration Rules window when the operation has completed.

21. Click Install in the Ready to Install window.

22. Once the installation is completed, click on Close in the Complete window.

 

Install SQL Server 2008 R2 Service Pack 2

You can download the SQL Server 2008 R2 Service Pack 2 from this link: https://download.microsoft.com/download/3/D/C/3DC6663D-8A76-40A6-BCF2-2808C385D56A/SQLServer2008R2SP2-KB2630458-x64-ENU.exe
1. When the download is complete, launch the installation and click Next in the SQL Server 2008 R2 update window.

2. Accept the license terms and click Next in the License Terms window.

3. Click Next in the Select Features window.

4. Click Next in the Check Files In Use window.

5. Click Update in the Ready to update window.

6. When the update installation is completed, click Close in the Complete window.

That’s it! You can now go ahead and install ConfigMgr 2012 SP1.