Installation and Configuration of the SQL Server Express Using Mixed Authentication Mode

<< Click to Display Table of Contents >>

Navigation:  Software Overview > RMS Monitoring Software > Server Software Installation > RMS Software V2.4.0 > RMS V2.4.0 Installation using MS Windows Server 2022 & MS SQL 2022 - Express Edition >

Installation and Configuration of the SQL Server Express Using Mixed Authentication Mode

Step 1

The SQL Server Express should be downloaded and available under downloads:

install v2.4.0 2

 

 

Right click on the "SQL2019-SSEI-Expr.exe" file and run as administrator:

install v2.4.0 3

Step 2

The following window will appear:

install v2.4.0 4

 

Select Download Media:

install v2.4.0 5

 

Select the following following language, package and download location and click on download:

install v2.4.0 6

 

The download will commence:

install v2.4.0 7

 

Once the download was successful, click on open folder:

install v2.4.0 8

Step 3

Under the download folder, a new file is available: "SQLEXPRADV_x64_ENU.exe".

install v2.4.0 9

 

Right click on the "SQLEXPRADV_x64_ENU.exe" file and run as administrator:

install v2.4.0 10

Step 4

Choose the directory for the extracted file:

install v2.4.0 11

 

Click on OK and the extraction will start:

install v2.4.0 12

Step 5

The following window will open:

install v2.4.0 13

 

Select "New SQL Server stand-alone installation or add features to an existing installation":

install v2.4.0 14

 

Read the License Terms and tick "I accept the license terms". Then click on "Next".

install v2.4.0 15

 

If needed, "Use Microsoft Update to check for updates" can be selected. Then click on "Next".

install v2.4.0 16

 

The following window will open. Click on "Next".

install v2.4.0 17

Step 6

Feature Selection: Select the features seen in the print screen (these are the standard features already offered by SQL when carrying out the setup). Then click on "Next".

install v2.4.0 18

 

IMPORTANT: If the data of the SQL server should be added to another location, update the instance root directory now as this cannot be changed afterwards!

Step 7

Instance Configuration: Change the named instance to SQLRMS and go to "Instance ID" with the tab key. SQL Server Setup will fill in the ID automatically with the named instance name. Then click on "Next".

install v2.4.0 19

Step 8

Server Configuration: Make sure that the SQL Server Browser is set to Automatic. Then click on "Next".

install v2.4.0 20

Step 9

Database Engine Configuration: Select the Mixed Authentication mode, then specify the password for the SQL Server system administrator (sa) account.

 

Recommendation Rotronic: Rotronic123.

 

Then click on "Next".

install v2.4.0 21

 

If using Windows authentication mode, then please follow the following manual for Windows Authentication: Installation and Configuration of the SQL Server Express Using Windows Authentication Mode.

 

If there are further questions, please reach out to rms@rotronic.ch.

 

The installation will then start:

install v2.4.0 22

Step 10

The SQL Server 2019 Setup is now complete. Click on "Close".

install v2.4.0 23

 

Update date: 24.07.2023