MSSQL On-Prem / Azure Managed – Create AimBetter SQL User Script

Create a Monitor User for AimBetter

Copy and Run this Create AimBetter SQL User Script on your SSMS tool with sysadmin permission. This SQL user name is “AimBetter”.

Replicated Database Monitor User for AimBetter

If you want to also monitor a replicated database (Secondary Database) such as mirror / log-shipping /Always On, after creating the AimBetter SQL User on the Primary Database:

1. On the Primary Database, run this Copy Monitor User Script.
2. Copy the output from the above execution.
3. On the Secondary Database, run this Create Monitor User on Secondary Database Script, replacing the word OUTPUT (besides @jobId =) in the script with the above output.