SQL 2k8 R2 Express new installtion steps;
Download your Express version from here; www.microsoft.com/express/Database/InstallOptions.aspx You really only need the Database Only version for RMS.
You can only install a 32 bit version on a 32 bit version of Windows. On a Windows 64 bit version, either will work, but reccommend the 64 bit version.
You will also need the download the SQL 2005 Backward Compatibility Componets from;http://go.microsoft.com/fwlink/?LinkId=204889
Lastly, if installing on XP, Vista, Server 2003 or 2008, make sure you have the Windows Installer 4.5 installed (look in Add/Remove Programs), otherwise grab it here;http://support.microsoft.com/kb/942288 You will need to restart the machine.
OK, lets get to the installation.
If Vista or Windows 7, right click on the downloaded SQL 2k8 R2 installation file and select "Run as Administrator"
First screen of the install asks for a new or Upgrade. Select New.
The installer will go out and check for any issues that must be fixed before the upgrade, if no issues, accept the license and optionally select the Send info to MS box.
On the Feature Selection screen, leave it as default
On the Instance Configuration screen, select Default instance.
Server Configuration screen, select "Use the same account for all SQL services, do the dropdown in the Account Name and select the Network Service option.
Database Configuration screen, select Mixed Mode and enter a password.
Next screen asks to send more installation info to MS.
Last screen completes or give you the errors that need fixing. If no errors, you're good.
Now find and double click on the SQL2k5 Backward Compatibility Componets .msi file, you really only need to install the SQL Distributed Management Objects, click on the down arrow of the others and select "This feature will not be available".
If standalone (single user), you're done, except we always setup for networked environments as you never know what the future brings...
Now, go to Start | All Programs | Microsoft SQL Server 2008 and delete the folder. Its duplicated with Microsoft SQL Server 2008 R2.
Start | All Programs | MS SQl Server R2 | Configuration Tools | SQL Configuration Manager | SQL Services on the right | right click on SQL Server and Stop it.
On the left, double click SQL Server Network Configuration | double on Protocols | make sure that Shared Memory, Named Pipes and TCP/IP are all enabled.
On the left, double click on SQL Native Client 10.0 Configuration | double click on Client Protocols, right click on Named Pipes | Order | on the right side, click the down arrow once so that Named Pipes is on the top.
Now install RMS, about the 3rd screen in, it offers to install SQL Server, select Skip.
Start | All Programs | MS Dynamics RMS | Client Network Utility | move Named Pipes and TCP/IP to the right with Named Pipes on top.. On the Alias tab | Add | make sure Named Pipes is selected and enter either the Server's name or IP address.
Go into SO or HQ Admin | log into the database | Query | New enter the following, but change the "databasename" for your install.
EXECUTE SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'
RECONFIGURE WITH OVERRIDE
EXECUTE SP_CONFIGURE 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
ALTER DATABASE "databasename" SET RECOVERY SIMPLE
EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'
Press the F5 button or select the green sideways triangle on the top.
FYI: The "show advanced options", AD Hoc, Show advanced turns on the old OPENROWSET that 2005 had, "Alter Database" sets it to a Simple backup mode so the log files don't grow, and the "autoclose" turns off the autoclose function of Express to stop it from going to sleep.
