Documentation forSolarWinds Observability

Requirements for monitoring SQL Server instances

You must have a user with the following privileges to monitor SQL Server and Amazon RDS SQL Server with SolarWinds Observability.

  • CONNECT SQL

  • VIEW SERVER STATE

  • VIEW DATABASE STATE

The privileges are required for the following purposes:

Privilege Description
CONNECT SQL A standard SQL Server permission required to connect to SQL Servers.

VIEW SERVER STATE

VIEW DATABASE STATE

Grants access to Dynamic Management Views (sys.dm_*) and are required for polling, metrics, etc. Monitoring will not start without these privileges.

Privileges Required for Azure SQL

The following are the required privileges for Azure SQL DB and Azure SQL Managed Instance.

Azure SQL DB

For Azure SQL DB, you must use the SolarWinds Observability Agent with an Azure SQL DB user who has the sysadmin role.

Azure SQL Managed Instance

For Azure SQL Manged Instance, the following privileges are required.

Privilege Description
CONNECT SQL A standard SQL Server permission required to connect to SQL Servers.

VIEW SERVER STATE

VIEW DATABASE STATE

Grants access to Dynamic Management Views (sys.dm_*) and are required for polling, metrics, etc. Monitoring will not start without these privileges.

The scripts are not supported under any SolarWinds support program or service. The scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.