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.  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'