Download RMS 3 Interface

Table of Contents
Table of Contents
RMS Database Administrator’s Guide ................................................................1
Overview .................................................................................................................. 1
Additional Documentation .............................................................................................. 2
System Requirements ............................................................................................... 2
Minimum Hardware Requirements .................................................................................. 2
Supported Platforms ....................................................................................................... 2
RMS Supported Databases ............................................................................................. 2
RMS Supported Scheduling Interfaces ............................................................................ 3
RMS Supported Web Browsers ....................................................................................... 3
RMS SDK Support ........................................................................................................... 3
Additional System Requirements .................................................................................... 3
Database Authentication ....................................................................................5
Overview .................................................................................................................. 5
SQL Login ................................................................................................................. 5
1) Add SQL Login Account to SQL Server....................................................................... 5
2) Add SQL Login Account to RMS Database ................................................................. 7
3) Configure RMS to use SQL Login ................................................................................ 9
Windows Authentication......................................................................................... 10
1) Create Domain User Account .................................................................................... 10
2) Add Domain User Account to SQL Server................................................................. 12
3) Add Domain User Account to RMS Database ........................................................... 14
4) Configure RMS for Windows Authentication............................................................. 16
a) RMS NT Services ....................................................................................................... 17
b) RMS Web Application (ASP.NET) .............................................................................. 21
Add "NT AUTHORITY\NETWORK SERVICE" Account to SQL Server .......................................... 21
Add "NT AUTHORITY\NETWORK SERVICE" Account to RMS Database..................................... 23
Add "NT DOMAIN\RMSServerMachineName$" Account to SQL Server ........................................ 25
Add "DOMAIN\RMSServerMachineName$" Account to RMS Database ........................................ 27
Additional Online References: ......................................................................................................... 29
c) RMS Configuration Wizard & RMS Database Wizard................................................. 29
Database User Permissions ...............................................................................31
Overview ................................................................................................................ 31
Flexible Access ....................................................................................................... 31
Restrictive Access ................................................................................................... 31
Database Installation ........................................................................................33
Overview ................................................................................................................ 33
RMS Database Administrator’s Guide
i