1. Home
  2. Settings
  3. MSSQL Settings
  4. MSSQL On-Prem / Azure Managed – Create AimBetter SQL User
  1. Home
  2. Settings
  3. Azure SQL Settings
  4. MSSQL On-Prem / Azure Managed – Create AimBetter SQL User

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

Create a Monitor User for AimBetter

Copy and Run this Create AimBetter SQL User 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.

Notice

For Priority customers:

Additional permission should be granted to enable AimBetter to display the Priority screen name of each query, as explained here.

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.

Notice

In the script of Step 3, substitute the word OUTPUT with the output from Step 2.