What Rights in SQL are Needed for DBAnalyze to Work?
I see this come up a lot when doing OCS Health Checks. Part of the Health Check is looking at information from DBAnalyze. If you get the following error, more than likely the account you're trying to use doesn't have the necessary rights to the SQL databases:
There was an error communicating with the database:
The object 'Resource' does not exist in database 'rtc' or is invalid for this operation.
In order for DBAnalyze to connect to the databases and gather the required information, the account that you are running DBAnalyze as needs to be db_owner on all of the RTC databases.