To Install Microsoft SQL Server 2005 Express Edition 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 Microsoft SQL Server 2005 Express Edition to Provide Database Support for RMS

To Install Microsoft SQL Server 2005 Express Edition 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 Microsoft SQL Server 2005 Express Edition.

  2. Download Microsoft SQL Server 2005 Express Edition from the Microsoft Web site https://go.microsoft.com/fwlink/?LinkId=64064 and save it to a location on your computer.

  3. Double-click SQLEXPR.exe file to begin the installation.

  4. Click I accept the licensing terms and conditions, and then click Next.

  5. Click Install to begin the installation of the Microsoft SQL Server Express Edition prerequisites, and then click Next.

  6. On the Welcome to the Microsoft SQL Server Installation Wizard, click Next, and then click Next again.

  7. Type your name into the Name: box, and then click Next.

  8. Click Next three times accepting default installation options, and then click Install. This will take several minutes to complete.

  9. Click Next, and then click Finish.

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 Express Edition be used to support RMS databases only in test environments because Microsoft SQL Server Express Edition does not include the tools necessary to fully operate and support an enterprise wide database. Additionally, because Microsoft SQL Server Express Edition 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 default installation of Microsoft SQL Server Express Edition does not include a way to manipulate or view the data that is stored in the RMS databases. In order to use this functionality, you must download SQL Server Management Studio Express available from the Microsoft Web site.