Prerequisites for monitored Azure SQL Databases

The following SQL scripts should be run in SQLCMD mode for every Azure SQL Database you want to monitor. To enable SQLCMD mode, open the Query menu in Management Studio and select SQLCMD mode.

Execute this in the master database:

:setvar username <TypeGovernorSQLLoginHere>
:setvar password <TypeVeryComplexPasswordHere>

CREATE LOGIN [$(username)] WITH PASSWORD=N'$(password)'
CREATE USER [$(username)] FROM LOGIN [$(username)]

ALTER SERVER ROLE ##MS_ServerStateReader## ADD MEMBER [$(username)];

Execute this in the user database:

:setvar username <TypeGovernorSQLLoginHere>

CREATE USER [$(username)] FROM LOGIN [$(username)]