Database Server Support for RMS

Updated: June 1, 2008

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

RMS uses a database server, such as SQL Server 2000, Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A, Microsoft SQL Server 2005, or Microsoft SQL Server 2005 Express Edition, to run the RMS configuration, logging, and directory services databases. You can use MSDE 2000 or Microsoft SQL Server 2005 Express Edition only in a single-server deployment. For failover protection, you can implement a database server cluster.

To support logging requirements, you can also run the configuration and logging databases on separate database server instances, or deploy a separate database server instance or cluster for the root cluster and licensing-only clusters. For more information about these options, see "RMS: Deployment " in this documentation collection.

By default, the RMS Service group has Execute permissions on the stored procedures for these databases. The user account that was logged on during provisioning has Database Owner permissions on these databases.

noteNote
It is recommended that MSDE 2000 and SQL Server 2005 Express Edition be used to support RMS databases only in test environments because these products do not include the tools necessary to fully operate and support an enterprise wide database. Additionally, because these products do not support remote networking, you must install it on the same server as RMS and you cannot add additional RMS servers to the RMS cluster. The terms of use for these products specify that you cannot use SQL Server client tools to manipulate them. With this restriction you will be unable to backup and restore the RMS configuration database, view logging information or directly modify data stored in the configuration database.

Community Additions

ADD
Show: