How do you use cloud databases? Take the survey.
Options

Errors on some PaaS Dbs

PeteForsterPeteForster Posts: 1 New member
in Redgate Monitor
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?
Tagged:
· Share on Twitter

Best Answer

  • Options
    Kendra_LittleKendra_Little Posts: 139 Gold 3
    Answer ✓
    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 :)
    · Share on Twitter

Answers

Sign In or Register to comment.