2.6 Understanding Microsoft SQL Server Permissions

When you install the Sentinel Agent Manager database server or reporting server components, the setup program automatically grants specific Microsoft SQL Server roles to the Sentinel Agent Manager service account you specify. These roles represent the minimum level of permissions required in SQL Server for Sentinel Agent Manager to function.

The setup program grants the following roles to the service account on the database server:

  • public server role

  • bulkadmin server role

  • db_owner role in the AgentManager and AgentManagerCommon databases

NOTE:You must use an account that is a member of the Microsoft SQL Server sysadmin role on the database server to use the Access Configuration utility.