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.

clip_image001_thumb2

In the wizard on the left side click on Installation.

clip_image002_thumb5

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

clip_image003_thumb2

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

clip_image004_thumb2

Accept the License Terms and click Next to continue.

clip_image005_thumb2

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.

clip_image006_thumb2

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.

clip_image007_thumb3

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

clip_image008_thumb1

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

clip_image009_thumb2

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.

clip_image010_thumb2

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.

clip_image011_thumb2

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

clip_image012_thumb3

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

image

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.

clip_image014_thumb2

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.

clip_image015_thumb2

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.

clip_image016_thumb3

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

clip_image017_thumb3

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

clip_image018_thumb2

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.

clip_image019_thumb4

You can monitor the installation of your SQL Server.

clip_image020_thumb3

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.

image_thumb97

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

image

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 *