Step 2

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

Step 3

Add the database name: rms.

No other settings require updating. Click on "OK".

Step 4

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

Step 5

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".

Step 6

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

Step 7

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.