Skip to main content
Kofax

Manually Change the KFS 4.x SQL Database Connection String

20168

QAID # 20168 Published

Question / Problem:

The hostname of the SQL Server that is hosting the Kofax Front Office Server database has changed. How can I change KFS configuration to point to the new SQL Server? Using the KFS database migration utility does not work in this scenario.

Answer / Solution:

To change the current configuration:

  1. Stop the KFS service and the World Wide Web Publishing service.
     
  2. Make a backup copy of \\<CaptureShare>\CaptureSV\KFS4.1\Config\hibernate.cfg.xml
     
  3. Open \\<CaptureShare>\CaptureSV\KFS4.1\Config\hibernate.cfg.xml in a text editor such as Notepad
     
  4. Locate the following line:
    <property name="connection.connection_string">…
     
  5. Replace the entire connection string line with one of the following (where Server\Instance is the server hostname and the name of the instance (if applicable),  Database Name is the name of the KFS database, UN is the SQL username, password is the SQL password):

    SQL Authentication:
    <property name="connection.connection_string">Data Source=Server\Instance;Initial Catalog=Database Name;User ID=username;Password="password";Application Name="Kofax Front Office Server"</property>

    Windows Authentication:<property name="connection.connection_string">Data Source=Server\Instance;Initial Catalog=Database Name;Integrated Security=true;Application Name="Kofax Front Office Server"</property>
     
  6. Save the changes to hibernate.cfg.xml
     
  7. Restart the KFS Service and the World Wide Web Publishing service.  When the KFS Service starts, it will encrypt the new connection string in the hibernate.cfg.xml file.

 

Applies to:

Product Version
KFS 4.0
  4.1

 

 

  • Was this article helpful?