This article only applies to Squared Up Version 2.0. If you're looking for help with Squared Up Version 3.0, please visit our new knowledge base

Overview

Squared Up displays performance metrics as graphs, sparklines and bar charts by connecting to the SCOM data warehouse using its IIS application pool identity. If Squared Up is unable to connect to the data warehouse you will not see sparklines from a server's 'View Performance', and you will see a blue data warehouse error message when viewing a dashboard that uses the performance plugin:


Check Data Warehouse Settings (No User Login)


If you do not see sparklines or Squared Up is particularly slow, follow the troubleshooting steps below.


Troubleshooting

Is the data warehouse connection configured?

See Configuring the data warehouse connection


Data warehouse connection shows as configured but still not getting sparklines/graphs?


If the Diagnostics page shows that your data warehouse is configured correctly but you are not seeing sparklines on the server 'view performance' page, then check that your SCOM management group is currently collecting metrics for the server you are viewing. For example, use the SCOM administration console to view metrics for the server.


If you still experience problems please contact support@squaredup.com who may ask you to configure the data warehouse permissions manually


Login failed for user...

If Squared Up describes the error as 'Login failed for user...' then the data warehouse permissions are not correctly configured. Specifically, this error indicates that a SQL login has not been created.

To resolve this issue, perform the auto configuration described (right hand menu, 'diagnostics', 'expand', 'perform auto configuration'), and if this fails see Configuring Data Warehouse Permissions Manually.


The SELECT permission was denied on the object...

If Squared Up describes the error as 'The SELECT permission was denied on the object...' then the data warehouse permissions are not correctly configured. Specifically, this error indicates that a SQL login has been created, but the login does not have the OpsMgrReader role on the data warehouse database.

To resolve this issue, perform the auto configuration described (right hand menu, 'diagnostics', 'expand', 'perform auto configuration'), and if this fails see Configuring Data Warehouse Permissions Manually


A network-related or instance-specific error occurred while establishing a connection to SQL Server...

If Squared Up describes the error as 'A network-related or instance-specific error occurred while establishing a connection to SQL Server...' then your data warehouse connection string may be out of date. Squared Up caches the connection string, so this can occur if you have recently moved the data warehouse and Squared Up was unable to update the cache.  See How to reconfigure Squared Up after moving the Data Warehouse and/or SCOM server 



If you still experience problems please contact support@squaredup.com and send the zipped up log files from C:\inetpub\wwwroot\SquaredUpv2\Log\


See also:

Configuring Data Warehouse Permissions Manually

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

Configure the data warehouse connection

No available data

Modifying the application pool identity