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”.
Notice
In this script, substitute {Password} with your chosen password.
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:
- On the Primary Database, run this Copy Monitor User Script.
- Take the output from the above execution.
- On the Secondary Database, run this Create Monitor User on Secondary Database Script where {Output from Primary Database} must be substituted with the above output.
Notice
In the script of Step 3, substitute {Output from Primary Database} with the output taken from Step 2.