DAVIS FMS DriveRight Database Selection Guide (8186) - Manual (Page 11)

11
The Database Connection dialog box displays the following fields:
• Server Name — Defaults to the local machine name. You may need to
change this if you do not use the local machine name.
• Database Name — Defaults to DriveRight_MSSQL but can be changed to
any other database running on the server.
• ODBC Driver — This will not need to be changed in most installations. If
version 2.5 of the SQL Server driver is installed (unlikely), then you will
need to edit it to look like {SQL Server}.
4. Once you have entered the pertinent information, click Connect to Database.
DriveRight FMS launches and connects to the database.
5. If the database is empty when you connect, you will be prompted to enter the
location name and address to be associated with all the data at your location.
After entering the location name and address, click Add and DriveRight FMS
will start.
6. Once the software has been configured on the MSDE/SQL Server, give
permissions to users to connect from multiple machines. This depends on how
your SQL Server is setup. A simple approach would be to grant permissions to
all Windows users to connect. In this case, the Windows Login/Password is
used to authenticate. This can be setup by running SQL Server Enterprise
Manager, going to Security->Logins and adding either individual users or
domain users.
7. From this point on, anyone who installs DriveRight FMS needs to enter the
MS SQL Server machine name in the Machine Name edit box in the
Database Connection dialog box. Contact your database administrator for the
MS SQL Server machine name.
To Configure the Database on a User’s Computer:
1. When you run DriveRight FMS software for the first time, the Database Type
Selection dialog box displays. Select SQL Server / MSDE and click OK.