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