Skip to main content
Kofax

EXECUTE permission was denied on the object Error 2147217495 when migrating to SQL Server using DBUtil

22178

QAID # 22178 Published

Question / Problem:

When attempting to move the SQL Server database using DBUtil, I receive an error message similar to the following:

Error -2147217495: User login failed. [4009] KdoLib: Error getting data reader from
stored procedure. The EXECUTE permission was denied on the object 'procGetBatchCount',
database 'Kofax', schema 'dbo'. (229)
(Line: 1)
(procGetBatchcount)

Answer / Solution:

If Kofax Capture was configured to use Windows Authentication, it may be found that the Windows User account was not configured with correct permissions in SQL Server.

Under that scenario, adding the account should allow for moving forward with the database migration.

You may also check to be sure the User account has the db_Owner role (taking the necessary precautions for a prior backup):

EXEC sp_AddRoleMember 'db_Owner', 'ACSystemRole'

Applies to: 

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0