Manually Change Connection String for SQL Server KFS Database

Issue

How to manually change the Connection String for the SQL Server KFS Database.

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.3\Config\hibernate.cfg.xml
    
3. Open \\<CaptureShare>\CaptureSV\KFS4.3\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.

Level of Complexity 

Moderate

Applies to  

References

N/A

​