SQL 2008 installed before RMS

The downside to this procedure is (local) won't work -- must use <servername>/instance -- and that means the DRS CR reports won't run on server. So preferred method is to install RMS with SQL 2005 first, update with SQL SP4, create a db, then upgrade the installed instance to 2008 R2. That is the highest version of SQL Server we recommend for RMS with DRS add-ins.

Install SQL2k8 Express http://tinyurl.com/ctxdr8c preferably the x86 version (RMS does not utilize 64 bit).  Go into the setup and remove the Shared Memory protocols and add both the Named Pipes and TCP/IP, with NP being 1st in order.

Next, install the SQL 2005 Backward Compatibility based on OS version (32 of 64 bit).

Then install RMS, skipping the SQL install.

Open SO Admin and run the following, changing the memory size in the Max Server section and the databasename to yours in the last 2 sections;

-- Turn on advanced options

EXECUTE SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

-- Set max server memory = 6400MB for an 8g Server machine  -- 1/2 for 4g

EXEC  sp_configure'max server memory (MB)',6400;
RECONFIGURE WITH OVERRIDE

 -- Turn on Ad Hoc Queries

EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'
RECONFIGURE WITH OVERRIDE

 -- Turn off advanced options

EXECUTE SP_CONFIGURE 'show advanced options', 0
RECONFIGURE WITH OVERRIDE

-- Turn off AutoClose in Express versions

EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'
RECONFIGURE WITH OVERRIDE

 -- Change Recovery Mode to Simple to prevent log file growth

ALTER DATABASE "databasename" SET RECOVERY SIMPLE