CloudMonix utilizes Dynamic Management Views to query diagnostic data from SQL Azure databases.  It will connect to master database for certain metrics and to monitored database for other metrics


To authorize query permissions against Dynamic Management Views utilize this script


  

-- in master database

CREATE LOGIN CloudMonixClient WITH PASSWORD = 'your_password_here' 
CREATE USER CloudMonixClient FROM LOGIN CloudMonixClient;

--per each database to be monitored

CREATE USER CloudMonixClient FROM LOGIN CloudMonixClient;
GRANT VIEW DATABASE STATE TO CloudMonixClient;