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.
Begin by opening the SQL Server installation file and choose Custom installation type.
Specify the SQL Server media download target location (or keep the default):
In the following screen select New SQL Server stand-alone installation:
Next, accept the license agreement and click Next.
In the next screen, check the box for updates and proceed.
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.
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.
In the following screen you can select your server instance name and ID. For this guide we are going to keep the default values.
Then, Accept to Install Microsoft R Open.
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.
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.
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.
Then the installation should start.
Once done, we will see Setup Completed Screen.
Then open SQL Server Management Studio and login with the 'sa' account credentials that you've already setup.