Foglight for SQL Server (Cartridge) 5.7.5.50 - Deployment Guide

Permissions for SQL Server databases

If you are using SQL Server®, ensure that these permissions are set.

NOTE: Monitoring mirroring requires sysadmin privileges.

* Creation of a new user is not required if a domain group with the appropriate permissions is used.

Grant Execute on these master database objects:

Grant Select on these msdb database objects:

Permissions for Sybase databases

If you are using Sybase®, ensure that these permissions are set.

Permission required — Sybase MDA Agent requires mon_role

In case the agent is created with a non-sa user, procedures need to be manually created on the monitored instance. This is achieved by executing the scripts available at the following directory:

<Agent Manager installation directory>\agents\SybaseCartridge\<version#>\config\Sybase\scripts\

Permissions for DB2 for LUW databases

If you are using DB2 LUW, ensure that these permissions are set.

Set Account Privileges on:

Grant Select privilege on:

Grant Execute on:

Required Monitor Switches

*Should be set to at least the base level.

Permissions

Grant Select on these SYSIBMADM administrative views:

* For DB2 version 9.7.0.1 or later

Grant Execute on to these table functions:

Grant Select on these views:

Permissions for monitored operating systems

For details, see the following topics:

The OS user account for each agent requires:

In addition to these general UNIX® system requirements, each agent user account requires additional privileges depending on the operating system, as specified in the following table.

NOTE: When monitoring DB2, SYSMON role and privileges for OS user is not required but is recommended to allow the installation to provide more information when discovering DB2 databases.

To monitor VMware®, users must have read only access to the virtual center.

Foglight support monitoring Windows® operating system in one of two ways: WinRM and WMI. The preferred method is WinRM when no WinRM connection WMI connection is used.

WinRM (default) - Based on Kerberos authentication or Basic authentication uses standard HTTP headers. For more information, see http://support.quest.com/technical-documents/foglight-agent-manager/5.9.2/foglight-agent-manager-guide/advanced-system-configuration-and-troubleshooting/configuring-windows-remote-management-winrm.

WMI (fallback) — Permission to access both DCOM and WMI. For more information, see

http://support.quest.com/technical-documents/foglight-agent-manager/5.9.2/foglight-agent-manager-guide/advanced-system-configuration-and-troubleshooting/configuring-windows-management-instrumentation-wmi.