Manually Change Connection String for SQL Server KFS Database
Article # 3031407 - Page views: 294
Issue
How to manually change the Connection String for the SQL Server KFS Database.
Solution
To change the current configuration:
- Stop the KFS service and the World Wide Web Publishing service.
- Make a backup copy of
\\<CaptureShare>\CaptureSV\KFS4.3\Config\hibernate.cfg.xml
- Open
\\<CaptureShare>\CaptureSV\KFS4.3\Config\hibernate.cfg.xml
in a text editor such as Notepad
- Locate the following line:
<property name="connection.connection_string">…
- 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>
- Save the changes to
hibernate.cfg.xml
- 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
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
Kofax Front Office Server | 4.3 4.1 |
All | N/A | N/A |
References
N/A
Article # 3031407