Install SQL Server 2012 SP1 for ConfigMgr 2012 SP1

This post will cover the necessary steps in order to prepare a SQL Server 2012 SP1 installation for ConfigMgr 2012 SP1.

Overview

  • Create Active Directory accounts
  • Prepare for the installation
  • Install SQL Server 2012 SP1
  • Install SQL Server 2012 SP1 CU2
  • Configure SQL Server memory

Create Active Directory accounts

Before you begin two Active Directory accounts needs to be created. The accounts could be named something like:

  • SQL_SDE (Server Database Engine account)
  • SQL_SA (Server Agent account)

Permissions for Server Database Engine account in Active Directory needs to be modified in order to automatically create the SPN’s correctly when the Database Engine service starts for the first time. Refer to this artice and perform Step 3http://support.microsoft.com/kb/319723

Prepare for the installation

For a successfully install of SQL Server 2012 SP1, you’ll need this at hand:

  • SQL Server 2012 SP1 installation media (download the ISO from MVLSC)
  • SQL Server 2012 SP1 CU2 (http://support.microsoft.com/kb/2790947/en-us)
  • A Windows Server 2008 R2 SP1 x64 server (minimum) with atleast 10GB memory
  • Optional: Disk configuration consisting of 3 volumes for optimal performance, see picture below

46_6

1. Before you begin, .NET Framework 3.5.1 needs to be installed. Run the following command in an elevated PowerShell command prompt:

2. Save the below configuration settings to a .ini file, e.g. SQLConfig.ini in C:\Install\SQLServer2012SP1. Make sure that you change the following rows for it to work in your environment:

  • SQLSVCACCOUNT=”CONTOSO\SQL_SDE”
  • SQLSVCPASSWORD=”P@$$w0rd
  • AGTSVCACCOUNT=”CONTOSO\SQL_SA”
  • AGTSVCPASSWORD=P@$$w0rd (this row should not contain any quotes)
  • SQLSYSADMINACCOUNTS=”CONTOSO\Administrator” “BUILTIN\Administrators”

3. Copy the contents of the SQL Server 2012 SP1 installation ISO into C:\Install\SQLServer2012SP1.

46_2

4. Open an elevated command prompt and browse to C:\Install\SQLServer2012SP1.
5. Run the following command:

46_4

6. The installation will now commence and you’ll see the progress on the screen. Since you’re launching the installation with all the necessary options from the SQLConfig.ini file, you won’t have to go though the long and time consuming SQL server installation wizard. Below picture is a screenshot of the progress of the installation. Once the installation has completed, the window will disappear.

46_5

Install SQL Server 2012 SP1 CU2

Why do you need to apply the CU2 update? If you examine the ConfigMgr 2012 SP1 prerequisites for a minimum configuration of SQL Server 2012 it says atleast SP1. But in SP1 there’s a known bug with NGEN that causes msiexec.exe into a loop. If you’d like to add the Reporting Services feature to take advantage of the built-in reports of ConfigMgr 2012 SP1, the installation of that Site System will fail. So in order to be able to install the Reporting Services point, CU2 for SQL Server 2012 SP1 needs to be applied. This Connect article shows a more detailed description of the issue: https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1#

1. Download the hotfix from the following URL: http://support.microsoft.com/kb/2790947/en-us
2. Extract the contents of the .exe file to C:\Install\SQLServer2012SP1CU2.
3. Launch SQLServer2012-KB2790947-x64.exe.
4. On the SQL Server 2012 update page, click Next.

46_7

5. On the License Terms page, check I accept the license terms and click Next.

46_8

6. On the Select Features page, click Next.

46_9

7. On the Check Files In Use page, click Next.

46_10

8. On the Ready to update page, click Update.

46_11

9. Once the update process has completed, click Close.

46_12

Configure SQL Server memory

When installing ConfigMgr 2012 SP1 it gives you a warning in the prerequisites checker if you havn’t configured the minimum memory usage on the SQL Server.

1. Launch Microsoft SQL Server Management Studio.
2. Right-click on the SQL Servers hostname in the Object Explorer pane, choose Properties.

46_13

3. Click on the Memory page to the left.
4. In the Minimum server memory and Maximum server memory fields, enter 8192. In my opinion it’s not good to let the SQL Server eat up all the memory available.

46_14

Your SQL Server 2012 SP1 server is now ready for ConfigMgr 2012 SP1 installation.

Tagged with: ,
Posted in ConfigMgr, ConfigMgr 2012, Install a ConfigMgr hierarchy, SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Link to my Contact
Recommend this page!
Link to my Linkedin Page
Link to my Rss Page
Link to my Twitter Page
Author
Last Tweets
  • their focus is in the cloud, very obvious for good or worse. Yeah I'm looking forward to see what's going to be announced on W10,
  • I hope that you guys get an awesome week with lots of fun and great experiences!,
  • yeah you were right, unfortunately. But I'm aiming for Ignite instead ;),
  • RT : New Blog Post: How can I deploy Windows 8.1 x64 to the Microsoft Surface Pro 3 using MDT 2013 ? ,
  • my application was denied :/,