When launching GoldMine on networked workstations, get error: ODBC SQL Server Driver: SQL Server does not exist, or access is denied.

Version 1

    Details

    When launching GoldMine on networked workstations, get error: ODBC SQL Server Driver: SQL Server does not exist, or access is denied.


    When this error occurs, GoldMine will not be able to launch on the application server either, and will produce a very similar error message if attempted. After rebooting the server the program will launch on the server without error. 

     

    IF you attempt to log into GoldMine Premium from a networked workstation again, the same problem will begin to reproduce, and will also then reproduce on the application server too. 

     


    Resolution

     

    In such instances the SQL Server configuration for the Microsoft SQL Server hosting the GoldMine database needs to be verified


    Important items to check to stop this error from reproducing:

    A. In SQL Server Configuration Manager >> SQL Server Network Configuration >> Protocols for MSSQLSERVER (or instance name)

    1. for Named Pipes Protocol

    >> make sure that Named Pipes protocol is enabled. (https://msdn.microsoft.com/en-us/library/ms191294.aspx

    >> make sure via right click >> Properties on the Named Pipes protocol that the correct Pipe Name is set or the default pipe \\.\pipe\sql\query is used (https://msdn.microsoft.com/en-us/library/ms189321.aspx)

    2. For TCP/IP Protocol

    >> make sure that TCP/IP protocol is enabled. (https://msdn.microsoft.com/en-us/library/ms191294.aspx)

    >> make sure via right click >> Properties >> Tab IP Addresses that the IP address is set correctly for this server. (https://msdn.microsoft.com/en-us/library/ms177440.aspx / https://msdn.microsoft.com/en-us/library/ms189310.aspx)



    B. In SQL Server Configuration Manager >> SQL Native Client xx.x Configuration (32-Bit)Network Configuration

    1. Client Protocols (https://msdn.microsoft.com/en-us/library/ms181035.aspx

    >> make sure that Named Pipes is enabled.
    >> make sure that TCP/IP is enabled.

    2. Aliases (https://msdn.microsoft.com/en-us/library/ms190445.aspx)

    >> Verify if and which Aliases were created and that they need and do match on the clients (Windows SQL Client Settings - cliconfg.exe feature) 

    C. on Workstations verify the Windows SQL Client Settings - cliconfg.exe feature
    1. on Windows 32-bit systems via C:\Windows\system32\cliconfg.exe or on Windows 64-bit systems via C:\Windows\SysWOW64\cliconfg.exe
    2. Tab General >> Enable Named Pipes and also enable TCP/IP (sort order should be Named Pipes prior TCP/IP)
    3. If applicable (see B.2.) - many times in environments with several MS SQL Servers set and verify the specific Alias for pointing to the MS SQL Server  hosting the GoldMine database
    3. OK