Some of our end-users still like to use the Activity Monitor in SQL Server. When setting up our SQL-server 2016 servers the activity monitor always ends up in a paused state when the users are not part of the "Administrators" group in Windows (on the server).
When the users are part of the Administrator-group all data gets through (so probably not a Firewall-problem). We also tried:
- Adding the users to the "Performance Monitor Users" and "Distributed COM Users"
- In COM: Changing the limits of "My Computer" and the permissions on "Windows Management and Instrumentation".
- The users also have the "View server state" permission in SQL Server.
Do you have any other suggestions?