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

If you chose to skip the automatic data warehouse configuration following installation, you can configure the data warehouse from the diagnostics page by following these steps. To perform the automatic configuration you must be logged in to Squared Up as a user with both SCOM admin rights, and SQL server sysadmin rights on the data warehouse database server see How to make a user a SQL sysadmin user.


1. Click the Diagnostics link in the right hand menu:


2. This will show a green tick if everything is configured correctly:


If Squared Up fails to connect to the data warehouse, it simply says 'Data warehouse connection' with no green tick:

3. Click 'expand' and you will see more information, for example 'The Squared Up web server does not have access to the data warehouse':



4. In the 'Automatic configuration' section click 'test permissions' to see if the Squared Up application pool identity can access the Data Warehouse.


5. If you get an error after 'test permissions', it means that Squared Up cannot access the data warehouse, so you need to perform the auto configuration.

6. Click on the 'perform auto configuration' button. This will create an SQL logon for the Squared Up application pool identity, and create a user in the data warehouse database with the OpsMgrReader role.


To perform the automatic configuration, please ensure that you are logged in to Squared Up with a user account that has both SCOM admin rights, and SQL server sysadmin rights on the data warehouse database server.


If you get an error after clicking 'perform auto configuration' please check that you are logged in to Squared Up as a user with SQL server rights on the data warehouse database server.

See also:

"An error occurred: Login failed for user" when auto configuring the data warehouse connection

"An error occurred: Cannot open database "OperationsManagerDW" requested by the login". When auto configuring the data warehouse connection


For instructions on how to configure the data warehouse connection manually see Configuring Data Warehouse Permissions Manually.


Related Articles


Configuring Data Warehouse Permissions Manually

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

No available data

Which ports do I need to open in my Firewall?

Getting Started - Installing Squared Up

Modifying the application pool identity

"An error occurred: Login failed for user" when auto configuring the data warehouse connection

"An error occurred: Cannot open database "OperationsManagerDW" requested by the login". When auto configuring the data warehouse connection