SQL Server checks when installing Configuration Manager 2012

Since System Center 2012 Configuration Manager is finally officially released and general available, it is time to write some blogs about this great product. Today I want to look at the installation prerequisite check before you install Configuration Manager 2012 on your server.

The installation prerequisite check is a very use full tool when you want to make sure that the installation of SQL Server is done the right way. After choosing “Assess server readiness” option from the System Center 2012 Configuration Manager Setup the installation prerequisite check will start. The installation prerequisite check will assess several items on the Operating System and environment and report if they apply for Configuration Manager 2012.

Some of the checks are related to SQL Server and its configuration. The following will be checked:

  • SQL Server version
  • Configuration for SQL Server memory usage
  • SQL Process memory allocation


SQL Server version:

The assessment tool will check if the SQL server applies to the following:

  • SQL Server 2008 SP2 with Cumulative Update 9
  • SQL Server 2008 SP3 with Cumulative Update 4
  • SQL Server 2008 R2 SP1 with Cumulative Update 6

Configuration for SQL Server memory usage:

The SQL Server is configured for unlimited memory usage. You should configure SQL Server memory to have a maximum limit.

SQL Process memory allocation:

Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio.

Other checks:

Especially the sizing guideline are a very nice addition to the following other SQL checks:

  • Verify and confirm connectivity to this SQL Server.
  • Verify and confirm if the SysAdmin rights are configured
  • Verify and confirm the SQL Server security mode
  • Verify and confirm SQL Agent logon settings.
  • Verify and confirm SQL Agent service status.
  • Verify and confirm the firewall settings for SQL Server accessibility.
  • Verify and confirm that the SQL Server is configured as not case sensitive.

If you want to check the system from the command line, you are able to assess the server with the following command line please check an earlier blog about the tool in the RC version of Configuration Manager 2012.

Check for more information about the sizing of your SQL Server this link which directs you to the Technet Documentation of System Center 2012 Configuration Manager.


Leave a Reply

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

Previous Post

First days in Las Vegas for MMS 2012

Next Post

Mastering System Center 2012 Configuration Manager released

Related Posts