"VIEW SERVER PERFORMANCE STATE permission was denied on object" error reported while validating connection for Microsoft SQL Server Management Pack in Aria Operations

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Error message while validating the connection for Microsoft SQL Server Management Pack:
VIEW SERVER PERFORMANCE STATE permission was denied on object ‘server’, database ‘master’.

Environment

Aria Operations 8.x and above

Cause

In Securables, the user did not have sufficient permissions.

Resolution

In securable, provided the following permissions to the user:

• View Server State

• View Any Definition