Question / Problem:
What can cause the following error when trying to launch Kofax Capture modules on a workstation?
 KdoLib: Network I/O error.: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (-1).
How can this issue be resolved?
Answer / Solution:
This error can occur if the workstation is not configured to use the same dynamic port that the SQL Server instance is listening on.
To resolve this issue:
- Determine the dynamic port that the SQL Server instance is listening on.
- Launch SQL Server Configuration Manager.
- Under the SQL Server Network Configuration, select Protocols for <Instance Name>.
- Right-click on TCP/IP protocol and select Properties.
- Under the IP Addresses tab, scroll down to the IPAll section where it shows the “TCP Dynamic Ports” value.
- Make an ODBC connection to the SQL Server instance using the dynamic port.
- Run odbcad32.exe from either the Windows\System32 folder for a 32-bit machine or from the Windows\SysWOW64 folder for a 64-bit machine.
- Click on the System DSN tab and add a new data source using SQL Server as the driver.
- Provide a test name and SQL Server (Ex. [Server Name]\[Instance Name]) and click on Next.
- Click on “Client Configuration”, uncheck “Dynamically determine port”, specify the dynamic port determined from Step 1 and click OK.
- Click Next which may result in an “Login failed for user” error which means that the workstation is now able to connect to the SQL server instance using the dynamic port. Now, click Cancel.
A registry key named [Server Name]\[Instance Name] is now created under the following registry hive:
For 32-bit systems:
For 64-bit systems:
The value of this registry key will contain the dynamic port.