Skip to content
  • There are no suggestions because the search field is empty.

What are the minimum SQL Server permissions required for Acctivate?

Learn which SQL Server permissions are required for a user account to run Acctivate successfully.

Acctivate requires specific permissions in Microsoft SQL Server to operate properly. At minimum, the SQL Server login used by Acctivate must have db_owner permissions on each Acctivate-related database.

To assign the appropriate permissions:

  1. Open SQL Server Management Studio (SSMS) and connect to the appropriate server.

  2. In the Object Explorer, expand the Security folder and then expand Logins.

  3. Right-click the login used by Acctivate and choose Properties.

  4. In the Login Properties window, select User Mapping from the left-hand menu.

  5. Check the box next to each Acctivate-related database (typically Acctivate, ACCTivateData, etc.).

  6. In the Database role membership section for each selected database, check db_owner.

  7. Click OK to save changes.

Expected Result:
The Acctivate user will have full access to the necessary databases, allowing Acctivate to function correctly.

Why db_owner is Required:
Acctivate performs a variety of operations that require elevated privileges, such as creating stored procedures, modifying data, and executing maintenance routines. Without db_owner, users may encounter permission errors or limited functionality.