I've started using SQLMonitor with some of our PaaS estate, however some databases on certain instances are getting errors when monitoring. In the status I can see monitoring stopped for some DBs with the following error: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.
The user has DBO on all of the user databases and I've also granted view database state on all of them. Not sure what else I can try as there is no view server state on PaaS?
Comments
2 comments
-
Hi Pete! I saw that you posted this in the SQL Server community slack channel as well, and I've responded there. No problem at all posting in both, just wanted to update you here that messages await you there
-
I am experiencing the same issue as PeteForster. Would you be able to post the solution here?
Add comment
Please sign in to leave a comment.