Skip to main content
Kofax

Database Utility connection errors when installing KFS 4.1 with the Standard Database

23000
306840

Question / Problem:

Installing Kofax Front Office Server (KFS) 4.1 with the Standard Database fails and rolls back the installation.  The DatabaseUtliityError.log reports the following errors:

Exception found with Create Sql Database

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Answer / Solution:

This issue is caused by a dependency on the old TLS 1.0 protocol in the Java Runtime Environment (JRE) version that is used by the KFS 4.1 Database Utility. Most versions of Windows have been updated to disable TLS 1.0 by default. Temporarily replacing the version of Java Runtime Environment installed by KFS with a new version that supports the newer TLS 1.2 protocol will allow the KFS installation to complete successfully.  This issue has been documented in TFS 887299.

 

To resolve this issue when installing KFS 4.1:

  1. Download the latest version of Java 8 Runtime Environment for Windows x64 from https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html
  2. Install Java 8 Runtime Environment using the downloaded executable
  3. Run regedit.exe
  4. In the Registry Editor, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\KeyExchangeAlgorithms
  5. Create a new key called Diffie-Hellman if one does not already exist
  6. Right-click on the Diffie-Hellman key, create a new DWORD, and name it Enabled 
  7. Right-click Enabled and select Modify
  8. Set the Value data to 1 and click OK
  9. Navigate to:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols
  10. Create a new key called TLS 1.2 if one does not already exist
  11. Right-click the TLS 1.2 key and create a new key called Server
  12. Right-click the Server key, create a new DWORD, and name it DisabledByDefault
  13. Right-click the Server key, create a new DWORD, and name it Enabled
  14. Right-click Enabled, and select Modify
  15. Set the Value Data to 1 and click OK
  16. Right-click the TLS 1.2 key and create a new key called Client
  17. Right-click the Client key, create a new DWORD, and name it DisabledByDefault
  18. Right-click the Client key, create a new DWORD, and name it Enabled
  19. Right-click Enabled, and select Modify
  20. Set the Value Data to 1 and click OK
  21. Close the Registry Editor
  22. Run services.msc
  23. Make sure that the Net.Pipe Listener Adapter status is Running.  If it isn't running, start the Net.Pipe Listener Adapter service.
  24. Install KFS 4.1
  25. When the installation reaches the InstallShield Wizard Complete screen, navigate to the newly installed C:\ProgramFiles (x86)\Kofax\Front Office Server 4.1
  26. Rename the existing jre folder to jre-OLD
  27. Navigate to C:\Program Files\Java and copy the newly installed jre1.8.0_xxx folder (where xxx is the build number of the installed version of Java 8 Runtime Environment)
  28. Paste the folder into C:\Program Files (x86)\Kofax\Front Office Server 4.1
  29. Rename the newly pasted folder from jre1.8.0_xxx to jre
  30. Copy the sqljdbc_auth.dll file from the jre-OLD\bin folder to the jre\bin folder.
  31. In the InstallShield Wizard Complete window, click Continue
  32. After the installation completes, install Service Pack 1 for KFS 4.1
  33. After Service Pack 1 has been installed, install the latest Fix Pack for KFS 4.1.1.

 

Applies to: 

Product Version
KFS 4.1

 

  • Was this article helpful?