Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    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:

              
     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance