One or a few users are being prompted for the GoldMine SQL Login credentials when logging into GoldMine

Version 1

    Details

    One or a few users are being prompted for the GoldMine SQL Login credentials when logging into GoldMine



    - Only one or a few users are being prompted for this information
    - All other users within the same network are logging into GoldMine successfully without prompt.1.

     


    Resolution

    [Cause(s)]

    1. The affected user(s) are not pointing to the correct gm.ini on the server that uses the dbalias.ini file to authenticate to the SQL server on the network
    2. The affected user(s) do not have the correct full read/write permissions to the GoldMine root directory on the server that contains the gm.ini and dbalias.ini
    3. The affected user(s) have the incorrect SQL server user name and password in  "User Properties" within GoldMine

    [Resolution(s)]
    The affected user(s) are not pointing to the correct gm.ini on the server that uses the dbalias.ini file to authenticate to the SQL server on the network
    On an unaffected workstation:
    1. Browse, locate and open the local copy of the file "gm.ini' in notepad
    - This will be located in the local GoldMine root directory
    2. The contents should be as follows:
    [GoldMine]
    realini=<UNC Path>\gm.ini or <Mapped Network Path>\gm.ini
    3. Notate the path
    4. Open up the local gm.ini file on the affected workstation
    5. Edit and save the file to match the path of the unaffected workstation

    Note: If necessary, map the network drive to the affected workstation.


    The affected user(s) do not have the correct full read/write permissions to the GoldMine root directory on the server that contains the gm.ini and dbalias.ini
    1. Contact your network administrator to verify that the affected users(s) have full read/write privileges to the GoldMine root directory(s) on the server

    Note: If the server is a 64bit Windows operating system and GoldMine was installed to the default installation directory, the directories will be split between:
    C:\Program Files (x86)\GoldMine\ and C:\ProgramData\GoldMine\

    The affected user(s) have the incorrect SQL server user name and password in "User Properties" within GoldMine
    1. Log into GoldMine as a user with "master" privileges
    2. Tools > Users' Settings
    3. "Properties" of the affected user > "Access" tab
    4. Delete or enter in the correct SQL authentication information in:
    "SQL Logon name:" and "SQL Password:" 
    5. OK > Close

    Note: By default, users authenticate to the SQL server via the dbalias.ini file in the GoldMine root directory on the server. The above entry is not necessary in most circumstances. If unsure, within Users' Settings > "Access" tab of an unaffected user, verify if the authentication credentials are present (or not).

    Related Knowledge Base articles:
    - 20089 "Is it OK to change the SQL SA password if it is not known?  If so how is this updated for GoldMine?"
    - 19111 "You do not know the SQL login details and cannot open GoldMine"