Install SQL Server 2014: SQL Server Installation

Microsoft SQL ServerIn this small series of posts I’m going to take a step through the installation of SQL Server 2014 and SSRS (the series index can be found at the bottom of each post).

The first item I’m going to cover is SQL Server itself; I have had problems before installing and configuring SSRS at the same time as SQL Server, so I now always separate these into three separate steps.

The first part is to install SQL Server; do so in SQL Server Installation Center by launching the setup.exe from the installation media:

SQL Server Installation Center - Planning

Click Installation and then click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center - Installation

Enter the product key and click Next:

SQL Server 2014 Setup - Product Key

Accept the license terms and click Next:

SQL Server 2014 Setup - License Terms

Decide whether you want to use Microsoft Update and click Next:

SQL Server 2014 Setup - Microsoft Update

A check will run through the install rules to validate prerequisites are present; the screenshot, below, shows a warning against Windows Firewall which is still enabled. The SQL Server port (typically 1433 for TCP/IP and 1434 for UDP) will need to be open.

If the install rules pass without error, click Next to proceed:

SQL Server 2014 Setup - Install Rules

The next step is to decide what to install; I’m going for the SQL Server Feature Installation:

SQL Server 2014 Setup - Setup Role

There are a wide variety of features available with SQL Server. I am installing those required for a Microsoft Dynamics GP test system. The features I selected are:

  • Database Engine Services
  • Client Tools Connectivity
  • Client Tools Backwards Connectivity
  • Management Tools – Basic
  • Management Tools – Complete
SQL Server 2014 Setup - Ready to Install

For Dynamics GP it is recommended to install it on its own instance of SQL Server. To do this I have chosen to configure a named instance called GP:

SQL Server 2014 Setup - Instance Configuration

On the Server Configuration step, you need to select the Account Name the service accounts should run under. I never leave it using a built-in service account; I prefer to create and use an AD account. I have changed both SQL Server Agent and SQL Server Database Engine to use this service account:

SQL Server 2014 Setup - Server Configuration - Service Accounts

With the service accounts entered, we need to change the collation of SQL Server from the default Windows collation to the supported SQL collation. Do this by clicking the Collation tab.

The default collation of Latin1_General_CI_AS will be displayed in the Database Engine field. Click on Customize to change the collation:

SQL Server 2014 Setup - Server Configuration - Collation

In the Customize the SQL Server 2014 Database Engine Collation window mark the SQL collation, used for backwards compatibility radio button.

The supported collation for Dynamics GP is SQL_Latin1_General_CP1_CI_AS; once you’ve selected this collation in the list, click OK:

Customize the SQL Server 2014 Database Engine Collation

The collation will have been returned to the Server Configuration window, so click Next to continue:

SQL Server 2014 Setup - Server Configuration

On the next step, set the Authentication Mode to Mixed Mode (SQL Server authentication and Windows authentication), enter and confirm the sa password and enter the SQL Server administrators:

SQL Server 2014 Setup - Database Engine Configuration - Server Configuration

I always prefer to change the data directories from the defaults to a simpler path to make the database, logs and backuops easier to handle. If this was a live server the data and log folders would be on separate physical drives, but in this example I am setting up a test system so they are all just on the C drive:

SQL Server 2014 Setup - Database Engine Configuration - Data Directories

The final step of the install is to check the selections you have made in the previos steps; if any changes are required, click Back, otherwise click Install to begin the installation:

SQL Server 2014 Setup - Ready to Install

Once the installation has finished a completion step will be displayed showing what has successfully been installed:

SQL Server 2014 Setup - Complete

Click Close to end the installation process.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

3 thoughts on “Install SQL Server 2014: SQL Server Installation

Leave a Reply

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