Technical FAQs

Ask a Question

SQL Server Agent Roles for ION Reporting Subscription Service

Issue
The necessary role memberships for ION login in MSDB database.

Product Line
Power Monitoring Expert (PME)

Environment
SQL Server Management Studio (SSMS)

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

Resolution
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 ?