To manually set the SQL login and database permissions for the AppClarity service account on Microsoft SQL Server 2008 R2:

  1. Run Microsoft SQL Server Management Studio.
  2. Expand the Security and right-click Logins.
  3. From the context menu, choose New Login....
  4. In the Login – New dialog, enter the name of the AppClarity service account (ACME\APPCLARITYSRV in our example) in Login name.
    Specifying the AppClarity service account
  5. In User Mapping, choose the AppClarity database and add the dbo schema and select the RoleAmpUserdatabase role (created by the installer).
    Adding the dbo schema and the RoleAmpUserdatabase role
  6. Click OK.