Skip to main content
Kofax

Database Utility Connectivity Errors Installing KFS 4.1 with SQL Server Database

3020386

Question / Problem: 

When installing KFS 4.1 using a SQL Server database, the installation fails at the Database Installation phase, causing the KFS 4.1 installation to roll back.  When the failure occurs, one of the following errors is reported:

  • Exception found with Create Sql Database
  • Error executing Installation: There was an error during the import
  • Import prodecure failed! There was no endpoint listening

Answer / Solution: 

Possible root causes for Database Utility connection errors to a SQL Server database during the KFS 4.1 installation include 

  • Security Protocol compatibility
  • SQL Server Protocol and Service Configuration
  • Services not running

To avoid common Database Utility connectivity issues during the installation of KFS 4.1, make the following configuration changes to the SQL Server and the server on which KFS 4.1 will be installed:

 

On the SQL Server:

  1. Run regedit.exe
  2. In the Registry Editor, navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\KeyExchangeAlgorithms
  3. Create a new key called Diffie-Hellman if one does not already exist
  4. Right-click on the Diffie-Hellman key, create a new DWORD, and name it Enabled 
  5. Right-click Enabled and select Modify
  6. Set the Value data to 1 and click OK
  7. Navigate to:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols
  8. Create a new key called TLS 1.2 if one does not already exist
  9. Right-click the TLS 1.2 key and create a new key called Server
  10. Right-click the Server key, create a new DWORD, and name it DisabledByDefault
  11. Right-click the Server key, create a new DWORD, and name it Enabled
  12. Right-click Enabled, and select Modify
  13. Set the Value Data to 1 and click OK
  14. Close the Registry Editor
  15. Run services.msc
  16. Make sure that the Net.Pipe Listener Adapter status is Running.  If it isn't running, start the Net.Pipe Listener Adapter service.
  17. Open the SQL Server Configuration Manager.
  18. Select SQL Server Services.
  19. Right-click SQL Server Browser and select Properties.
  20. Select the Log On tab. If the service status is not running, click Start.
  21. Select the Service tab and set the Start Mode to Automatic
  22. Click OK to close the SQL Server Browser Properties window.
  23. Select SQL Server Network Configuration | Protocols.
  24. Right-click TCP/IP and select Enable.
  25. Right-click Named Pipes and select Enable.
  26. Close the SQL Server Configuration Manager.
  27. Open the Microsoft SQL Server Management Studio and connect to the SQL Server instance that contains the KFS database.
  28. Delete the partially-installed KFS Database (if one exists)
  29. Create a new, empty database that will be used as the KFS Database.
  30. Close the Microsoft SQL Server Management Studio.

 

On the Server where KFS will be installed:

  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. Install KFS 4.1
  22. When the installation reaches the InstallShield Wizard Complete screen, navigate to the newly installed C:\ProgramFiles (x86)\Kofax\Front Office Server 4.1
  23. Rename the existing jre folder to jre-OLD
  24. 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)
  25. Paste the folder into C:\Program Files (x86)\Kofax\Front Office Server 4.1
  26. Rename the newly pasted folder fromjre1.8.0_xxx to jre
  27. Copy the sqljdbc_auth.dll file from the jre-OLD\bin folder to the jre\bin folder.
  28. In the InstallShield Wizard Complete window, click Continue
  29. After the installation completes, install Service Pack 1 for KFS 4.1
  30. After Service Pack 1 has been installed, install the latest Fix Pack for KFS 4.1.1.

 

Applies to:  

Product Version
KFS 4.1