Invalid SQL username or password when attempting to install the agent
When attempting to install the Active Administrator agent, the error “Invalid SQL username or password. Please retype the user and password and try again. If you are using Windows authentication please ensure that the Audit Agent startup account is a member of the AA_Admins group.” Is displayed:
The Active Administrator service account have missing permissions on the target SQL Server instance where the databases are hosted.
Please follow the troubleshooting steps below:
Verify that the account used is in the AA_Admin group. By default this group is either local on the SQL server, or global in Active Directory Users container, depending on what was selected when the database was created.
Also, within SQL go to Security | Logins and highlight the account. The User Mapping permissions for the account must have “AA_Admin_Role” and “public” checked, as shown below:
Next, verify that the account is able to log into the SQL Management Studio and view the Active Administrator database.
If the error below, “Login failed for user” is displayed, add the account explicitly within SQL | Security | Logins
