beautypg.com

Database configuration, To configure the database on the server – DAVIS FMS DriveRight Database Selection Guide (8186) User Manual

Page 10

background image

10

Database Configuration

The MS SQL server can be configured two ways, on the server itself or from a
user’s computer.

Note: The server can also be configured without installing DriveRight FMS on the server, by

running the DBConfig_DriveRight_MSSQL.bat file. See “Appendix A: Configuring MS
SQL Server Database Manually” on page 17.

To Configure the Database on the Server:

1. With MS SQL Server running, install and run DriveRight FMS on the same

machine as the database server. This is only required for the database
configuration. After the database is configured you can uninstall the
DriveRight FMS from the server. When the database configuration is
complete, you will be able to connect to the MS SQL Server from any PC on
the local area network.

2. When you run the DriveRight FMS for the first time, the Select Database

Type dialog box displays. Select SQL Server / MSDE and Click OK.

3. When DriveRight FMS is run for the first time, the Database Connection

dialog box displays after selecting SQL Server / MSDE as your database.