How-to Install Configuration Manager 2012 R2 – Step-by-Step [Part 2]

Hi !

As per my previous post, here is the part two about SQL 2012 installation and quick configurations.

Installing SQL Server

From the installation media, double click on “Setup.exe”

Select “New SQL Server stand-alone installation …”

SQL Server 2012 Installation
SQL Server 2012 Installation

Click “Ok” after the Setup Support Rules ran

SQL Server 2012 Installation
SQL Server 2012 Installation

Fill in the product key or select evaluation mode and click “Next”

Accept the licence agreement and click “Next”

Select any product updates and click “Next”

SQL Server 2012 Installation
SQL Server 2012 Installation

The setup support rule will occurs, click “Next” if everything pass, in case of problems, check using status link and re-run the setup support rule action before going further.

SQL Server 2012 Installation
SQL Server 2012 Installation

Select “SQL Server Feature Installation” and Click “Next”

SQL_Install_5
SQL Server 2012 Installation

Select the feature as per the last print screen and click “Next”

SQL_Install_6
SQL Server 2012 Installation

Leave the instance ID by default, you can edit the root directory if needed and click “Next”

SQL_Install_7
SQL Server 2012 Installation

Click “Next”

SQL Server 2012 Installation
SQL Server 2012 Installation

In the following wizard you can personalize accounts that will be used by SQL server to run services. In the following example, I did configure a service account for SQL Engine as well as for SQL Reporting. You can as well let default setting. As soon as configurations are confirmed, click on “Collation” tab.

SQL Server 2012 Installation
SQL Server 2012 Installation

Click on “Customize”, select the “SQL Collation, used for backwards compatibility” and finally choose “SQL_Latin1_General_CP1_CI_AS”. Click “Next”.

SQL Server 2012 Installation
SQL Server 2012 Installation

Select “Windows Authentication Mode”. You must as well add at least one administrators to the DB, you can either add the current user or as per the example, add an AD group. The AD group can ease the management of administrative users instead of nesting a user

SQL_Install_11
SQL Server 2012 Installation

Set reporting Services to “Install only”

SQL_Install_12
SQL Server 2012 Installation

Set reporting preferences and click Next and then click “Install” to start the installation process.

As soon as the installation process is completed, open SQL Server Management Studio (SSMS)

Go to “Properties” of the SQL Server

SMSS

set the RAM limit to 50% of total RAM or if you have enough RAM, set the limit to 8 GB in order to avoid warning during Configuration Manager Setup.

Both maximum and minimum value have to be set.

Et voila, your Database setup is ready for Configuration Manager Setup !

 

David Gaillard

Leave a Reply