How to Recover a Data Warehouse Management Server
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
You can use the following procedure to reinstall a data warehouse management server for System Center 2012 – Service Manager.
You must restore the encryption key before starting this procedure. For more information, see How to Restore the Service Manager Encryption Key.
To recover a data warehouse management server
Log on to the computer that will host the new data warehouse management server using an account that has administrator rights.
On the Service Manager installation media, double-click the Setup.exe file.
On the Service Manager Setup Wizard page, click Service Manager data warehouse management server.
On the Product registration page, type the information in the boxes. If applicable, click I have read, understood, and agree with the terms of the license agreement, and then click Next.
On the Installation location page, verify that sufficient free disk space is available, and then click Next. If necessary, click Browse to change the location in which you want to install the Service Manager data warehouse management server.
On the System check results page, make sure that the prerequisite check passed or at least passed with warnings, and then click Next.
On the Configure the data warehouse database page, do the following:
In the Select a database to change its default properties area, select Staging and Configuration.
In Database server, type the name of the computer that is hosting data warehouse databases, and then press the TAB key.
Select Use an existing database.
Click the Database list, select the database name for the Staging and Configuration database (the default name is DWStagingAndConfig), and then click Next.
On the Configure the data warehouse management group page, wait until the Management group name and Management group administrators fields have been populated, and then click Next.
On the Configure the reporting server for the data warehouse page, in the Report server text box, type the computer name of the computer that hosts SQL Server Reporting Services (SSRS), and then click Next.
You must use the original URL for the Reporting Server.
On the Configure the account for Service Manager services page, click Domain account; specify the user name, password, and domain for the account; and then click Test Credentials. Make sure that you receive the following message: "The credentials were accepted.", and then click Next.
On the Configure the reporting account page, specify the user name, password, and domain for the account, and then click Test Credentials. After you receive a “The credentials were accepted” message, click Next.
On the Help improve System Center page, indicate your preference for participation in both the Customer Experience Improvement Program and Error Reporting. For more information, click Tell me more about the program, and then click Next.
On the Use Microsoft Update to help keep your computer secure and up-to-date page, indicate your preference for using Microsoft Update to check for Service Manager updates, and then click Next.
On the Installation summary page, click Install.
On the Setup completed successfully page, click Close.