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 the SCOM server has moved
If the data warehouse has moved
Squared Up picks up the Data Warehouse location from SCOM, and stores it in the state.xml file. If you've moved the Data Warehouse, first update SCOM, then check the state.xml file, as described below, and finally ensure that the Squared Up application pool identity has the correct permissions to access the Data Warehouse database.
1. Update the Data Warehouse Connection for SCOM
1. Check the SCOM DW connection by running the following Powershell command in the Operations Manager Shell:
If this is incorrect then you need to update the Data Warehouse connection for SCOM.
For full details see this Microsoft article: How to Move the Data Warehouse Database.
Get-SCOMDataWarehouseSetting again to check that SCOM now has the correct Data Warehouse location.
2. Ensure Squared Up is picking up the new Data Warehouse location from SCOM
1.As a SCOM admin, log on to Squared Up and check the Settings page from the right hand menu. This causes Squared Up to read the Data Warehouse location from SCOM and write to the state.xml file.
2. Locate the C:\inetpub\wwwroot\SquaredUpv2\AppState\state.xml file and check that the Data Warehouse location is correct.
If it is not correct, it could be that Squared Up is not able to write to state.xml and so it caches the new setting in memory, but will forget it when restarted.
If Squared Up can't write to the state.xml file it is likely to be due to the Squared Up application pool not having the correct permissions to the Squared Up folder structure. You can reset the correct permissions by following this article: Checking and modifying the application pool identity
3. Log back into Squared Up and check the settings page again.
4. Check that the C:\inetpub\wwwroot\SquaredUpv2\AppState\state.xml file has been correctly updated this time.
3. Configure the data warehouse permissions
If you have created any dashboards using the SQL plugin connecting to the Data Warehouse, you will need to change the connection string to the new DW connection string (instead of "global:dw").
If you are moving Squared Up to another server
You will need to run through the licence migration procedure with Squared Up, see Migrating a licence to a new server