5 minute readApplies to: v4

Troubleshooting the Data Warehouse connection

Overview

SquaredUp displays performance metrics as graphs, sparklines and bar charts by connecting to the SCOM Data Warehouse using the SquaredUpv4 IIS application pool identity.

If SquaredUp is unable to connect to the Data Warehouse you will not see graphs anywhere is SquaredUp, for example when browsing to the Performance perspective for a server.

If no graphs are showing anywhere in SquaredUp or SquaredUp is particularly slow, follow the troubleshooting steps below.

If you are having problems with some Performance graphs see Troubleshooting the Performance tile.

Symptoms

No performance graphs shown in SquaredUp. Performance tiles may be blank or you may see one of the following errors:

connection-failed-blocking: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

connection-failed-no-sql-server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

access-denied-table: Cannot open database "PerformanceDataContext" requested by the login. The login failed. Login failed for user '<application pool identity>'

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

Troubleshooting

Is the Data Warehouse connection configured correctly?

Ensure that the Data Warehouse connection is properly configured

There are two parts to the Data Warehouse connection: The Data Warehouse connection string in SquaredUp, and the permissions to the Data Warehouse database.

Connection

You can check that the Data Warehouse connection string specified is correct for the specified SCOM server by going to the right-hand menu in SquaredUp ☰ > system > Connections.

Permissions

You should also check that the SquaredUpv4 application pool account has the OpsMgrReader role for the Data Warehouse database.

For more information on checking both the connection and permissions see How to configure the Data Warehouse connection.

If you have migrated the Data Warehouse to a different server, you will need to reconfigure SquaredUp to use the new location. See How to reconfigure SquaredUp after moving the Data Warehouse and/or SCOM server

Login failed for user

If you see Login failed for user on a Performance tile this indicates that a SQL login has not been created for the SquaredUp application pool identity.

LoginFailedForUser

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'

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

To resolve this issue see How to configure the Data Warehouse connection or How to configure the Data Warehouse permissions manually.

If you see Login failed for user when running through the setup wizard configuring the Data Warehouse then this means that there is a problem with the SQL login for the user you are logged in with. See "Login failed for user" when configuring Data Warehouse.

Some graphs are blank or show an error

If you are seeing some graphs in SquaredUp, this means the Data Warehouse connection is configured correctly. If some Performance tiles show blank or show an error you should troubleshoot these tiles individually.

For example:

timeout-command: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

No values found for the given metric for the last 12 hours at the resolution 'raw/hourly/daily'.

See Troubleshooting the Performance tile

Further Issues

If you still experience problems please contact SquaredUp Support and reply to the automatic response with the output of the SquaredUp Diagnostics and a screenshot of the problem.

How to configure the Data Warehouse connection

How to configure the Data Warehouse permissions manually

How to make a user a SQL sysadmin user

Access denied error when viewing tiles

"Login failed for user" when configuring the Data Warehouse

How to reconfigure SquaredUp after moving the Data Warehouse and/or SCOM server

How to use the Performance tile

Troubleshooting the Performance tile

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