This document assumes that your server is being replaced and RMS is currently functional on your existing server which houses your data.
Before you start you must ensure that you have your most recent RMS backup available and it can be read by the computer that you are currently running RMS from.
If you do not have a backup but DO have access to the files on the existing server it may be possible to copy the data from this drive to the new one. Please contact RMS Support if this is the case.
You will also require internet access from the new server.
All steps indicated below must be performed using a Windows user with Administration rights.
RMS can be installed by using the appropriate files from either the Installation CD or by downloading the relevant files from our Customer Support web page.
If you are re installing RMS from a CD that is pre April 2008 it will have come with a version of SQL called MSDE.
This version of SQL has been replaced by SQLExpress 2008 – which is available on our web page or on CD’s post April 2008.
Specific notes relating to Windows Small Business Server (SBS)
RMS strongly recommends NOT using Windows SBS as the SQL Server in your RMS environment.
Windows SBS servers come preinstalled with SQL Server so the standard RMS installation instructions do not apply and may cause damage to your SBS installation.
RMS cannot provide support for the installation or configuration of SQL Server on Windows SBS.
Do NOT attempt to install SQL Express on one Small Business Server
Ensure that the system is set to English Australian regional settings through the Control Panel. Often (if you have reformatted or have a new PC) you will find that the system will be set to English American.
Install all critical Microsoft security updates via Windows Update. This step is very important.
Install SQL Express 2008 from the Installation CD (or RMS Webpage) and restart the PC. Check that it has been installed by looking in Programs and Settings in Control Panel. It would be listed as SQL Server (MSSQLSERVER). Unlike MSDE (the older version of SQL) it does not display an icon in the system tray.
Make a folder on C drive that will store RMS form letter files etc. This folder should be called RMSWIN (c:\RMSWIN). Share this folder on the network (FULL ACCESS RIGHTS TO ALL USERS).
Install the full version of RMS from the CD or Webpage (you will need a password from RMS Support to download the version from our Webpage). Do not change any installation options. If prompted for a password enter cat.
It is now time to restore the RMS backup;
Open the RMS Connection Wizard (Start > All Programs > RMS for Windows > Connection Wizard)
Select Choose an Existing Database and click Next (you may receive an error message at this stage, simply click ok to continue)
In this order - Set the username to sa and the password to that set during Step Four, THEN set the SQL Server to (local).
You should see your database name appear down the bottom - Select it
Make sure the shared data path says C:\RMSWIN (as created in Step Five and used in Step Seven)
Select Finish to save the database and shared path settings
Failure to complete this step will leave RMS inoperable as it will not be at the version that coincides with the restored data.
Install the RMS Configurator from the RMS install CD or from the RMS Webpage.
Once installed, the Configurator will download and install all further required updates.
Allow this to complete all updates. If you are asked for your Client ID or Client Number you must enter the correct client number for your property. If you are unsure of this number please contact RMS Support.
The Configurator should be running all of the time - simply minimize it to the system tray.
Once the Configurator has completed you can run RMS from the shortcut icon found on your desktop (RMS for Windows). Any further updates queued by the Configurator would be installed at this time.
RMS should load to the Login Screen or Main Menu.
Any workstations on the network that were using data from the old server need to have their connection wizards updated to reflect the new server and shared data path.
From each workstation, run the connection wizard and choose an existing database.
You may receive an error (this is because it cannot find the old server), choose ok to continue.
The order in which you follow these steps is important…
Set the Username to sa
Set the password to that used when SQL was installed
Set the SQL server (using the drop down list) to the name of the new server
You should now see the database name below – select it.
You must set the shared data path to point back to the RMSWIN folder on the new server. This must be in the form of a UNC style path such as \\server\rmswin (use the browse button to browse through the network to locate the RMSWIN share)
Click Finish to complete the new connection.