Install RMS

Previous  Top  Next

The RMS application is comprised of two components: RMS Client and RMS Server.

Installing RMS for use on a single computer

You will need to install the RMS Server and the RMS Client onto this single computer. It is recommended to install the RMS Server first.

1. Follow the instructions given in the Install the RMS Server Help topic

2. Follow the instructions given in the Install the RMS Client Help topic

Installing RMS for use on multiple computers

You will be installing the RMS Server onto a single computer (either a server or one of the user's computers that will be designated as the server) and then installing the RMS Client on the computers of the people who wish to use the application. If you will be installing RMS Server on a shared computer server, be sure that you are running the installation when a system reboot, which may be required by the RMS Server installation, will not disrupt other users.

If your company has a computer server that is running Microsoft SQL Server 2000 or 2005, go to Step 4.

1. Follow the instructions given in the Install the RMS Server Help topic to install the RMS Server onto a single computer that will be acting as the server. This computer must be accessible via local area network (LAN) or wide area network (WAN) by all other computers that will have the RMS Client installed.

2. Install the Microsoft SQL Server Management Studio Express onto the server computer. This is the GUI (graphical user interface) for SQL Server and will enable you to easily restore databases and add user accounts. Use this link to navigate to the page to download and install this software: http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

Note: Microsoft's web site often changes and if this link no longer works, use a search engine with the key words "SQL Server Management Studio Express 2005 Download" and you will find the dowload page.

3. Configure the server firewall to allow remote connections. (For more information see the Microsoft Help topic http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277)

Open the Windows Control Panel (Start | Control Panel)

Double click the Windows Firewall icon

Click on the Exceptions tab

Click the Add Program button; click the Browse button and locate c:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe and click the Open button; click the OK button

Click the Add Program button; click the Browse button and locate C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe and click the Open button; click the OK button

Click OK to close the Windows Firewall

4. Restore the database.

Open Microsoft SQL Server 2005 by clicking on Start | All Programs | Microsoft SQL Server 2005 | SQL Server Management Studio Express

At the Connect to Server dialog box, select SQL Server Authentication from the Authentication text box drop down list

Type "SA" for the Login

Type the password that you created during the RMS Server installation and click the Connect button. If this SQL Server was not installed by the RMS Server installer, then simply login with an account that has system administrator rights.

Right click the Databases folder in the Object Explorer and click Restore Database

When the Restore Database dialog box opens, type in the name of the database in the To database text box (it doesn't need to be the same as the database that you are restoring).

Click on the From Device option button and click on the button to the right of that text box to browse for the backed up database device file

Click on the Add button and search for the device file; once you have found the device file you wish to use (see Note below) Click the OK button; Click the OK button

Note: If you wish to use the file that is installed by the RMS Server installation, it is located at c:\Program Files\Railcar Tracking Co\RMS\RMSDBSQLDemo.bak. If you have already been using RMS on a single computer and wish to preserve that data, back up that database (see the Backing up the database Help topic) and copy the .bak file created from that backup procedure to a local hard drive of the server

Check the Restore check box next to the backup set listed in the Select the backup sets to restore list box

You will need to specify where the database files (data file *.mdf and log file *.ldf) will be stored. Click on he Options page link in the Select a page pane on the upper left corner of the Restore Database dialog

Under the Restore As heading, click on the button with three dots on it to the right of the file name entry, select the folder path c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and then type in the file name RMSDBSQL.mdf. Do the same for the _Log file and give it the file name of RMSDBSQL_log.ldf. Click OK.

5. Add user accounts (see Add a SQL Server Login and User Help topic in the Advanced Topics chapter) or all may use the SA account with the password created during the Server installation.

6. Follow the instructions given in the Install the RMS Client Help topic for each computer that will need access to the system.