Creating an SQL Server database user for RMS

When installing the RMS it is recommended that the install program uses the 'sa' or similar user to create the database. However, once the database is created we recommend creating a new database user that only has control over the RMS database. This will increase the security of the software.

The RMS install program will:

  1. Setup the components and database during the installation process using the 'sa' account

  2. Launch the Configuration Application

The RMS administrator will need to:

  1. Create a new database user for the RMS

  2. Assign the database user as the owner of the RMS database

  3. Fill in the details of the database user and database server in the Configuration Application

  4. Fill in the detail for the Perception database in the Configuration Application

This section describes how to create database users and assign it to the RMS database created by the installer in:

These steps will need to be completed after the RMS installer has created the RMS database, for instructions on running the RMS installer please refer to the chapter Running the install program

The database server also requires mixed mode authentication enabled to ensure that the users created can be accessed. If your database server does not have mixed mode enabled, please refer to the section below for instructions:

Once the database user has been created refer to Using the Configuration application for instructions on how to apply the database user to the RMS database.

Creating a database user for the RMS in SQL Server 2000

Once you have created your database, you need to set up a new login. To do so:

  1. Open the SQL Server Enterprise Manager

  2. Expand the server folder for the server on which you have created your database in the navigation pane

  3. Expand the Security sub-folder

  4. Right-click Logins and select New login...

  5. Enter a name for the new login

  6. Select SQL Server Authentication and enter a password

  7. Select the database created by the RMS installer from the Default database drop-down list, this will be the name supplied in the RMS Database Name text-box during the installation

  8. Open the Database Access tab and tick the database you have created

  9. Tick the db_owner box to assign permissions

  1. Click OK

  2. Re-enter the new password and click OK to complete the login creation process

Once a user has been assigned to the RMS database created by the installer, this information will need to be provided to the Configuration Application.

Creating a database user for the RMS in SQL Server 2005

Once you have created your database, you need to set up a new login. To do so:

  1. Open the SQL Server Management Studio

  2. Expand the server folder for the server on which you have created your database in the navigation pane

  3. Expand the Security sub-folder

  4. Right-click Logins and select New login...

  5. Enter a name for the new login

  6. Select SQL Server Authentication and enter a password

  7. In the Default database list, select the database created by the RMS installer

  8. Open the User Mapping page and tick the database you created

  9. Tick the db_owner box to assign permissions

  1. Click OK

Once a user has been assigned to the RMS database created by the installer, this information will need to be provided to the Configuration Application.

Enabling mixed mode server authentication

The process of enabling mixed mode authentication varies depending on which version of SQL Server you are using. Select the correct version below for further details.

Enabling mixed mode server authentication for SQL Server 2005

To enable mixed mode authentication complete the steps below:

  1. Launch the SQL Server Management Studio

  2. Login to the database server with the System Administrator user (this was defined when the database server was installed)

  3. Right-click on the on the database connection in the Object Explorer window and select Properties

  1. Select the Security page

  2. From the Server authentication options click SQL Server and Windows Authentication mode

  3. Click OK to apply the changes

You can now use the database user you created to access the RMS database.

Enabling mixed mode server authentication for SQL Server 2000

To enable mixed mode authentication complete the steps below:

  1. Launch the SQL Server Enterprise

  2. Login to the database server with the System Administrator user (this was defined when the database server was installed)

  3. Right-click on the on the database connection in the Console Root window and select Properties

  1. Select the Security tab

  2. From the Security options click SQL Server and Windows

  3. Click OK to apply the changes

You can now use the database user you created to access the RMS database.