During the upgrade of Operations Manager 2012R2 it is possible that you encounter some problems. For example, starting the upgrade process for Operations Manager 2012 R2 the following error is shown in some cases: “Setup is unable to proceed with installation for the following reason: “Setup could not detect the current Data Warehouse scenario. Please ensure That the SQL Server service for the Data Warehouse is running, and the current User has permission to access the Data Warehouse” (Figure 1).
Figure 1. Operations Manager 2012R2 upgrade error: Unable to Proceed.
In such a case the names of the Data Warehouse Database and the Data Warehouse Database Server are missing in the registry and therefore the setup cannot be continued. To check this go to “HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft Operations Manager \ 3.0 \ Setup” to determine if the values of the “DataWarehouseDBName” and “DataWarehouseDBServerName” are present. If not, please add the Data Warehouse Database Name and Data Warehouse Server name as shown in Figure 2. Subsequently, restart the Operations Manager 2012R2 installation. The error should be resolved.
Figure 2: Data Warehouse Database name and the Data Warehouse Database Server name in registry.
Good post! It remains strange that tr installer is not able to handle this kind of common situations