When starting GoldMine on a client workstation you receive an SQL Login timeout and a request for SQL credentials, when cancelling and trying again to login it works

Version 1

    Details

    When starting GoldMine on a client workstation you receive an SQL Login timeout and a request for SQL credentials, when cancelling and trying again to login it works.

    [PRE-REQUISITS]
    - GoldMine properly installed and shared on the application server
    - GoldMine properly installed on the client's workstation as networked client
    - MS SQL ports available through Firewall

    [STEPS TO REPRODUCE]
    1. Start GoldMine on the networked client
    2. Provide a proper user name and credentials
    3. OK

    [RESULT:]

    - It may take some some time and then a message appears: SQL Login timeout
    - When pressing OK on this message a further request for entering the SQL credentials for the GoldMine database appears



    - When the user enters the credentials (if they are aware of it) or cancelling the dialog and retry to login, the user will be able to login into GoldMine now without any further issue until the machine is rebooted.





    Resolution

    [RESOLUTION]
    - On the client enable Named Pipes and TCP/IP in the SQL Server Client Network Utility

    Please  keep in mind that related to the client’s operating system the  appropriate SQL Server Client Network Utility (Cliconfg.exe) must be  started
    1. Open the appropriate 32-bit SQL Server Client Network  Utility dialog box via  Start > Run > Type the appropriate  32-bit path\cliconfg.exe  > Click OK or press Enter


                                                      
     

    OS Platform  

     
     

    Application   platform

     
     

    Cliconfg.exe   path

     
     

    X86

     
     

    X86

     
     

    C:\windows\system32

     
     

    X64

     
     

    X86

     
     

    C:\Windows\SysWOW64

     
     

    X64

     
     

    X64

     
     

    C:\windows\system32

     

    For Example
    - On Windows XP machines / Windows 2003  Server (no 64-bit environments are supported with GoldMine products): 
    Start > Run > cliconfg > OK   

    - On newer 32-bit Operating Systems like Windows  7 - Windows 10/ and also certain Windows Server OS in 32-bit:
    Start > Enter into Search  programs and files > cliconfg > press Enter

    - On newer 64-bit Operating Systems like Windows 7 - Windows 10 and Windows Server 2088 - 2012 64-bit:
    Start > Enter  into Search programs and files > C:\Windows\SysWOW64\cliconfg.exe > press Enter

    2. General Tab  > Enable TCP/IP and Named Pipes



    3.  When using several MS SQL Servers in your environment, it might be  considered to create a specific Alias for pointing to the MS SQL Server  hosting the GoldMine database.
    3. Click Apply
    4. Click OK