Technical FAQs

Ask a Question

SQL Server Agent Roles for ION Reporting Subscription Service

The necessary role memberships for ION login in MSDB database.

Product Line
Power Monitoring Expert (PME)

SQL Server Management Studio (SSMS)

ION Reporting Subscription service manages report schedules and has a dependency on SQL Server Agent service for delivering. As such the ION login needs to have proper role membership.

SQL Server has the following msdb database fixed database roles, which give administrators finer control over access to SQL Server Agent. The roles listed from least to most privileged access are:
- SQLAgentUserRole
- SQLAgentReaderRole
- SQLAgentOperatorRole
When users who are not members of one of these roles are connected to SQL Server in SQL Server Management Studio, the SQL Server Agent node in Object Explorer is not visible. A user must be a member of one of these fixed database roles or a member of the sysadmin fixed server role to use SQL Server Agent.

The ION login should be assigned role membership to the above roles in MSDB database:

Was this helpful?
What can we do to improve the information ?