SQL Account Permissions Required for Day to Day Operations

What type of permissions does the SQL account need to run for day to day operations?

Here are the basic requirements, which are followed by details.

• During installation, Kofax Capture (with “Create new database” selected) creates the SQL Server

database. Therefore, the database login provided during installation must be a member of the

db_owner role, and it requires permissions to create a database.

• You can also move to an existing SQL Server database after installation, in which case the database

login does not need permissions to create a database.

• For everyday Kofax Capture use, the database login does not need to be a member of the db_owner role.

• During upgrades and service pack installations, the database login must be a member of the db_owner role.

This information can be found in the KC Installation guide under the "Database Permission" section.

Easy

Product	Version	Build	Environment	Hardware
Kofax Capture	11.X	N/A	N/A	N/A

Add any references to other internal or external articles