Message

Possible cause

Login failed

• Windows user name or domain name incorrect.
• Windows password is incorrect.
• Account does not have permissions to access the Data Repository database.
• Permissions can't be escalated to Log on as service (required for the account to run the Base Monitor service).

Login failed for user <username>

SQL Server user name or password incorrect.

Login failed for user <username>. Reason: the password of the account must be changed

Password policy has been enforced for this SQL Server login. The password must be changed.

The SELECT permission was denied on the object...

SQL Server account has only minimum access permissions to this instance.

Make sure the Windows login or database user associated with this SQL Server login isn't a member of db_denydatareader group.