How to: Set up SQL Server Express for Digital Assistant

Installing SQL Server

This guide will go through installing SQL Server 2017 Express Edition on a Windows Server 2016.

Once you click the link above to install the SQL Server, you can see the below page to download and run the .exe file.

Click download to install SQL Server.

Begin by opening the SQL Server installation file and choose Custom installation type.

SQL Server installation type

Specify the SQL Server media download target location (or keep the default):

SQL Server install specify media download location

In the following screen select New SQL Server stand-alone installation:

SQL Server New Installation

Next, accept the license agreement and click Next.

SQL Server Accept Agreement Screen

In the next screen, check the box for updates and proceed.

SQL Server Install Check for updates

The setup will then run a few tests to identify any potential problems. If everything is correct you should see something similar to the following picture.

SQL Server Install Fault check status

Now you can proceed to the feature selection screen, where you can specify the installation directory, features to install, etc. For this tutorial, we are going to keep the default values.

SQL Server Install Feature install selection screen

In the following screen you can select your server instance name and ID. For this guide we are going to keep the default values.

SQL Server Install Instance name selection screen

Then, Accept to Install Microsoft R Open.

SQL Server Installation Service Accounts selection

In the next screen it is important to set the authentication mode to 'Mixed' and input a strong password for the 'sa' (System Administrator) account. Then click *Next* to proceed.

SQL Server Install Set Mixed Authentication mode

At this point the installation should start. It takes several minutes and once it is done you should see a screen that summarises successfully installed features.

SQL Server Installation Success

Installing SQL Server Management Studio

To control Microsoft SQL Server it is recommended to install the SQL Server Management Studio. First, download the latest version of Microsoft SQL Server Management Studio and start the installation. For this tutorial we're going to install Microsoft SQL Server Management Studio v17.8.1.

In the initial screen click Install.

SQL Management Studio starting screen

Then the installation should start.

SQL Management Studio Installation progress

Once done, we will see Setup Completed Screen.

SQL Management Studio installation restart prompt

Then open SQL Server Management Studio and login with the 'sa' account credentials that you've already setup.

SQL Management Studio login page