Access denied error when viewing tiles

Symptoms

Squared Up dashboard shows the following error instead of data in a tile:

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

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

access-denied-table

Cause

The Data Warehouse connection is not correctly configured.

Resolution

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 label: Access denied error when viewing tiles keywords: error can’t Data Warehouse login fail access denied table access-denied-table dw OperationsManagerDW