Hands on with Microsoft SQL Server 2017: Install the Database Engine Services

November 28th, 2017 by

Microsoft Dynamics GPIn this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.

The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.

In this, the first post of the series, I am going to install the core part of Microsoft SQL Server 2017, which is the Database Engine Services. To do this double click the Setup.exe on the installation media.

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

SQL Server Installation Center - Installation

The Product Key will default in, so click Next:

SQL Server 2017 Setup - Product Key

Mark the box to accept the license terms and click Next:

SQL Server 2017 Setup - License Terms

Decide if you want to ,em>use Microsoft Update to check for updates and click Next:

SQL Server 2017 Setup - Microsoft Update

The next few pages of the installer skipped past without requiring any input until I was deposited at the Feature Selection stage.

There were two features I selected in the list:

  1. Database Engine Services
  2. Client Tools Backwards Compatibility

Once you’ve selected all of the required features, click Next:

SQL Server 2017 Setup - Feature Selection

As I am installing this instance of SQL Server for use with Microsoft Dynamics GP, I have selected a Named Instance of GP. Once done, click Next:

SQL Server 2017 Setup - Instance Configuration

I prefer to use a Domain Service Account for running the SQL Server services, so have entered the Account Name and Password against both the SQL Server Agent (which I also set to Automatic Startup Type) and the SQL Server Database Engine:

SQL Server 2017 Setup - Server Configuration

If you are installing SQL Server on a US English language Windows server, the collation will have defaulted to a supported collation, but if you have, for example, an UK English install the collation will be an unsupported one.

Click the Collation tab to verify the collation. In this example, I am using a US English server so the collation is correct:

SQL Server 2017 Setup -

If you need to change the collation, click the Customise button, find SQL_Latin1_General_CP1_CI_AS and click OK:

SQL Server 2017 Setup - Customize the SQL Server 2017 Database Engine Collation

Click Next to proceed to the Database Engine Configuration stage. Dynamics GP required Mixed Mode so mark the radio button and enter and confirm a password for the sa account.

Click the Add Current User button or Add… to add administrators for SQL Server:

SQL Server 2017 Setup - Database Engine Configuration

Click the Data Directories tab and change the directory fields as required (assuming you don;t want to use the default locations.

Click Next to proceed:

SQL Server 2017 Setup - Database Engine Configuration

Review the selected configuration and click Install to begin the installation:

SQL Server 2017 Setup - Ready to Install

Once the installation is complete, review the status and click Close:

SQL Server 2017 Setup - Complete

Click to show/hide the Hands on with Microsoft SQL Server 2017 Series Index

Hands on with Microsoft SQL Server 2017
Install the Database Engine Services

Read original post Hands on with Microsoft SQL Server 2017: Install the Database Engine Services at azurecurve|Ramblings of a Dynamics GP Consultant

Source: azurecurve

Leave a Reply

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