To Install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) to Provide Database Support for RMS

  • Article

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

Installing MSDE 2000 to Provide Database Support for RMS

To Install MSDE 2000 to Provide Database Support for RMS

  1. Log on using a domain account that is a member of the local Administrators group on the server on which you want to install MSDE 2000.

  2. Download MSDE 2000 from the Microsoft Download Center (https://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147\&DisplayLang=en) and save it to a location on your computer.

  3. Run the MSDE2000A.exe file to extract the MSDE 2000 setup package to a folder. By default, this folder will be named MSDERelA, but you may specify a different name.

  4. Open a command prompt and navigate to the location in which you saved the MSDE 2000 installation.

  5. Type the following command to set up the Microsoft SQL Server 2000 Desktop Engine application with the correct configuration to work with RMS, and replace password with a strong password of your choice:

    Setup.exe /i setup\sqlrun10.msi INSTANCENAME=RMS DISABLEAGENTSTARTUP=1 SAPWD= password

    Important

    The MSDE service must be started after it is installed. You can start the service from Services in Administrative Tools Control Panel. We recommend that the service be configured to automatically start to ensure that the MSDE database is always available when RMS is running.

Do not provision RMS on a server until you have a database installed to support the RMS configuration database.

It is recommended that Microsoft SQL Server Desktop Engine be used to support RMS databases only in test environments because Microsoft SQL Server Desktop Engine does not include the tools necessary to fully operate and support an enterprise wide database. Additionally, because MSDE does 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 Microsoft SQL Server Desktop Engine specify that you cannot use SQL Server client tools to manipulate a Microsoft SQL Server Desktop Engine database. 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.