Skip to main content
Kofax

How to manually update the Documents - Data Layer - database connection string

Article # 3035066 - Page views: 147

Issue

The Document database Data Layer (DL) connection string exists in the TotalAgility table SERVER_DATA.   Typically, it is possible to update this connection string within the KTA Configuration tool, however, if this is not possible for some reason, you can do this manually using the steps below.

 

Solution

  • Update (replace) the KTA SERVER_DATA table CEBPM_SETTINGS column with the new DL connection string:
UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 
'OLDCONNECTIONSTRING', 'NEWCONNECTIONSTRING')

For example:

UPDATE server_data SET CEBPM_SETTINGS = REPLACE(CAST(CEBPM_SETTINGS as varchar(max)), 'Data
Source=W2K8-SQL2019;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False', 'Data
Source=SQLINSTANCE;Initial Catalog=TotalAgility_Documents;User ID=;Password=;Integrated
Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False')

You may need to restart IIS and the KTA services to apply the change. 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KTA 7 all n/a Windows n/a

References

Add any references to other internal or external articles

 

Article # 3035066
  • Was this article helpful?