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

Create a Monitor User for AimBetter

Copy and run the following script on your SSMS tool with sysadmin permission. In this script, the username is AimBetter, and you need to substitute {Password} with your chosen password.

• 👉AimBetter MSSQL User Script

Replicated Database Monitor User for AimBetter

If you also want to 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 script
   • 👉 Copy Monitor User Script.
2. Copy the output from the above execution.
3. On the Secondary Database, run the following script, replacing the word OUTPUT (besides @jobId =) in the script with the above output.
   • 👉AimBetter Replica MSSQL User Script