Skip to main content

Schema is not Empty error using DBUtil to change SQL Server name to FQDN


Question / Problem:

When using the Database Utility (DBUTIL) and trying to change the database from domain to Fully Qualified Domain Name for the SQL server name, I'm getting the following error:

Error 1004: A database error occurred while moving the database (8004102A, [4142] KdoLib: The database schema is not empty.: Kofax.KfxDb.KfxDbException)

How can I fix this?

Answer / Solution:

To change the SQL Server name to the Fully Qualified Domain Name:

  1. Stop the KC service
  2. Make a backup copy of the ACConfig.xml file
  3. Modify the ACConfig.xml file Database section <KfxDB> to use the FQDN for the server name.
  4. Restart the Kofax Capture service

Applies to: 

Product Version