Step by step – Installing ConfigMgr 1511 in https – Part 3: Installing & Configuring SQL Server 2014 SP1

Installing SQL Server 2014 SP1

In this setup, we will use SQL Server 2014 SP1. If you would like to read more about Supported Versions of SQL go here.

Browse to the location of your SQL Installation sources and click on setup.exe.


In the wizard on the left side click on Installation.


On the right side click New SQL Server Stand-alone installation or add features to an existing installation.


Enter your product key or specify if you want to use a free edition of SQL Server and click Next to continue.


Accept the License Terms and click Next to continue.


The setup will check some Global Rules to identify problems that might occur during the installation. if everything Passed the check, click Next to continue.


Now you have the choice to use Microsoft Update to check for updates or you can just leave this blank and click Next to continue.


If an update is found, the setup will install them accordingly. click Next to continue.


Setup will identify potential issues, if you have any issues make sure that it is fixed before you continue. Click Next to go on.


Time to select the features that we would like to use. You can choose to have all the features installed with the default values. But we don’t need all the features,  so we will select SQL Server Feature installation and click Next.


For ConfigMgr, we need the features below:

  • Database Engine Services
  • Reporting Services – Native
  • Management Tools

If you are using a dedicated disk for your SQL installation, it’s here that you will need to specify your Drive & Location. In my lab, the S:\ Drive is dedicated for SQL Server installations. Click Next to continue.


The wizard will check for possible issues that might block the installation process, in case of any issue, resolve and click Next to continue.


I’m using the default instance here. Click Next to continue


Right now it’s important that you remember the Service Accounts that we created in Part 1.  As you can see in the print screen, I have configured my Service Accounts with the password. I also changed the Startup Type of SQL Server Agent to Automatic.


On the second tab, we need to set the Collation properly. The collation that we will use is SQL_Latin1_General_CP1_CI_AS. Click OK and Next to continue.


Time to configure some security, we will need Windows Authentication Mode. Add the Security Group that contains your SQL Admins by clicking on Add and if the account that you’re using to install SQL is not part of that group, click on Add Current User. click Next to continue.


For the reporting point, select Install only and click Next.


Another check will run for possible issues that might block the installation process. When everything is Passed, click Next to continue.


An overview will be displayed with your current configuration of the SQL Server installation. I can give you the advice to copy the ConfigurationFile.ini to a known location for later use. This will allow you to make the installation of SQL unattended. Click Next to start the installation.


You can monitor the installation of your SQL Server.


When done, close the wizard and continue with the next step.

Configuring SQL Server 2014 SP1

Now that we have installed our SQL Server it’s important to configure some settings. Let’s start with the memory configuration. It’s important to have the Minimum and Maximum server memory configured.

Open the SQL Server Management Studio, connect to your instance, and right click on the Instance.


Limit the amount of RAM SQL can use to 50% for the minimum and 80% for the maximum.


Click OK and close the SQL Management Studio for now.

That’s it for Part 3, in the next post we will go prepare our Server for HTTPS.

Stay Tuned!!

Leave a Comment

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