Versions Compared

Key

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

...

Consider the following requirements when installing SQL Diagnostic Manager in an environment where the components are on separate computers.

Info
titlePermissions and Privileges
  • Windows Permissions: Your Windows Logon account includes local Administrator permissions.
  • SQL Server Privileges: Either windows user account or SQL Server login that includes System Administrator privileges on the monitored SQL Server instances,

...

Type

Requirement

SQL Server Standard or Enterprise Edition

  • SQL Server 2000 SP4 or later
  • SQL Server 2005 SP1 or later
  • SQL Server 2008 or later
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • SQL Express 2008
  • SQL Server Express 2008 R2
  • SQL Server Express 2012
  • SQL Server Express 2014
  • SQL Server Express 2016
  • Microsoft SQL Azure
  • Amazon RDS
  • SQL Server 2017 (Windows & Linux)
Info
titleAWS

To monitor an Amazon RDS instance using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following permissions:

Roles: public

Other permissions (under the Securables tab in using SSMS): View server state, View any definition, View any database, and Connect SQL.

Note

No OS Collections supported on Linux under monitored versions.

...