Creation of a New Database 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 >

Creation of a New Database Using Mixed Authentication Mode

Step 1

Using the Windows search function open the SQL Server Management Studio. Click "Connect".

install v2.4.0 49

 

Select "SQL Server Authentication" as Authentication. Insert "sa" as a login and "Rotronic123" as a password. Click on "Connect".

install v2.4.0 50

Step 2

Create the RMS database. Right click on "Databases" and select "New database".

install v2.4.0 51

Step 3

Add the database name: rms.

 

Set the initial Size (MB) to 128 MB:

install v2.4.0 52

Step 4

Move to Autogrowth / Maxsize and edit the field to 128MB, for rms and rms_log:

install v2.4.0 53

 

install v2.4.0 54

 

Click on OK.

Step 5

Create a user for the database login. Got to "Security" and expand. Right click on "Logins" and select a "New login".

install v2.4.0 55

Step 6

General: Add the login data for the SQL database user.

 

Remove the enforce password policy.

 

Recommendation:

Login name: rmsUser

SQL Server authentication password: Rotronic123

 

IMPORTANT:

This user login must be specified later for the WebService so that the RMS server software can access the database.

Use only letters and numbers for the password. The password will be used when installing the server software. Special characters could create a conflict.

Default database: rms

 

Click "Server Roles".

install v2.4.0 56

Step 7

Server Roles: Select the "Public" role. Click "User Mapping".

install v2.4.0 57

Step 8

User Mapping: Select "rms" in users mapped to this login.

 

Select "db_datareader" and "db_datawriter" as well as "Public" from the database role membership for: rms. Click "OK".

 

Configuration of the database is finished.

install v2.4.0 58