1 minute readApplies to: v3

Login failed for user on Performance tile

Symptoms

Performance tiles anywhere in SquaredUp show the following error instead of a graph:

access-denied-table: Cannot open database 'database' requested by the login. The login failed. Login failed for user 'Application Pool Identity'

access-denied-user: Login failed for user 'Application Pool Identity'

The application pool identity and database name may differ in your environment. For example:

access-denied-table

LoginFailedForUser

Cause

The Data Warehouse connection is not correctly configured.

For example, this happens if the SquaredUpv3 application pool identity has been changed, but not given the OpsMgrReader role for the Data Warehouse database.

Resolution

To resolve this issue see How to configure the Data Warehouse connection

How to make a user a SQL sysadmin user

How to configure the Data Warehouse connection

"Login failed for user" when configuring the Data Warehouse

Troubleshooting the Performance tile

Troubleshooting the Data Warehouse connection

Squared Up Ltd. (c) 2020Report an issue with this article