Versions Compared

Old Version 12

changes.mady.by.user Alejandra Barrientos

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The IDERA Dashboard and SQL BI Manager connect to registered SQL Server instances and their host computers to collect information. The collection service requires permissions requires permission to connect and gather information using SQL and WMI connection credentials.

...

AccountActionPermissions required
Windows user account or Windows security group user accountTo install IDERA Dashboard and SQL BI Manager componentsWindows Administrator permission on the Target computer

To create and access the Core and SQL BI Manager repository databases

  • Create Database Rights on the target SQL Server Instance
  • Read and write privileges on the Core and SQL BI Manager Repository Databases



SQL Server login account

For most SQL queries

VIEW SERVER STATE

VIEW ANY DATABASE

VIEW ANY DEFINITION

To monitor database information

ALTER ANY DATABASE server-level permission or

CREATE DATABASE in the master database

For DBCC CHECKDBsysadmin server roles
WMI accountTo access remote WMI dataAdditional rights on a group that has been given remote access

...