|
Title:
HOW TO:
Use Mixed-Mode SQL Server Authentication with FLEETMATE Enterprise
Overview:
The official recommended and supported approach to
establishing a FLEETMATE Enterprise session with your FLEETMATE database running
on SQL Server database is to use Integrated Security. When you do this, a
connection string will be automatically created, stored in the PC registry, and
will be managed automatically by FLEETMATE for use in other areas of the
software. User authentication is managed internally by Windows using Integrated
Security. This standard type of connection string will appear similar to
the sample below.
SAMPLE:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MYDB;Data Source=MYSERVER
WHERE:
MYDB = Your database
name
MYSERVER = Your server
name
For those customers
that choose not to use Integrated Security, the following is an alternate approach.
However, this approach does not offer the security features offered by
the Integrated Security approach described above.
CAUTION:
This process involves manually altering a connection
string value in the registry for FLEETMATE Enterprise. Incorrectly altering
values in the registry on your PC can render your PC unusable. Therefore, it is
recommended that this process be performed for you by your IT support
personnel.
Step-by-Step:
-
Create the SQL Server
Login
Your Database Administrator will need to create a SQL Server login
(username and password) for you that is associated with your FLEETMATE
database. The
Database Role Membership should include: 1)-db_datareader,
and 2)-db_datawriter.
-
Edit the Registry on
Your PC
Open Registry Editor and navigate to:
HKEY_CURRENT_USER\Software\SCB\FLEETMATE Enterprise\General
-
Modify the ConnStr
value
Double-click on the ConnStr value
to open it. Edit the value following the syntax below:
Provider=SQLNCLI10;Server=server;Database=database;Uid=login;Pwd=password;
Example:
Provider=SQLNCLI10;Server=Comp1;Database=FLEETMATE;Uid=johnd;Pwd=easter;
-
Close Registry Editor
Notes:
Once this connection string has been manually updated, the user should not
use the File | Database | Open... menu function in FLEETMATE. Otherwise the
connection string value manually entered above will be lost. There are security
implications using this approach. Please contact us for additional information.
|