TECHNICAL ARTICLE: howto_018.htm

 Close Window  

 
 


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:

  1. 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.
     

  2. Edit the Registry on Your PC
    Open Registry Editor and navigate to:
         HKEY_CURRENT_USER\Software\SCB\FLEETMATE Enterprise\General
     

  3. 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;
     

  4. 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.



If you need additional assistance, please write or call us:
 support@FLEETMATE.com 
410-282-3603


FLEETMATE Software Copyright (c) 2005-2013 by SCB Consulting.  All rights reserved.
FLEETMATE is a registered trademark of SCB Consulting, LLC.