How to Install a New Data Warehouse Server in the Lab Environment
Applies To: System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager
Use the following procedure to install a new data warehouse management server in the lab environment.
To install a data warehouse management server and data warehouse databases
Log on to the computer by using an account that has administrative rights.
On the Service Manager installation media, double-click the Setup.exe file.
On the Microsoft System Center Service Manager 2012 R2 page, click Install a Service Manager data warehouse management server.
On the Product registration page, type information in the boxes. In the Product key boxes, type the product key that you received with Service Manager, or alternatively, select Install as an evaluation edition (180 day trial)?. Read the Microsoft Software License Terms, and, 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 the Service Manager data warehouse management server will be installed.
On the System check results page, make sure that prerequisites passed or at least passed with warnings, and then click Next.
On the Configure data warehouse databases page, Service Manager checks your computer to determine whether the computer can host the data warehouse databases. For this configuration, confirm that the database server is the computer on which you are installing the data warehouse management server, and then click Next.
Warning
A warning message appears if you are using the default collation (SQL_Latin1_General_CP1_CI_AS). Support for multiple languages in Service Manager is not possible when you are using the default collation. If later you decide to support multiple languages by using a different collation, you must reinstall Microsoft SQL Server. For more information, see “Microsoft SQL Server 2008 with SP1” in Planning for System Center 2012 - Service Manager.
On the Configure the data warehouse management group page, perform the following steps:
In the Management group name box, type a unique name for the group.
Warning
Names of management groups must be unique. Do not use the same management group name when you deploy a Service Manager management server and a Service Manager data warehouse management server. Furthermore, do not use the management group name that is used for System Center Operations Manager.
Click Browse, enter the user account or group to which you want to give Service Manager administrative rights, and then click Next.
Service Manager will use the existing computer if SQL Server Reporting Services is present. On the Configure the reporting server for the data warehouse page, accept the defaults, and then click Next.
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. After you receive a The credentials were accepted message, 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 the Customer Experience Improvement Program and in Error Reporting. Optionally, 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.
To validate the installation of a data warehouse management server
On the computer that is hosting the data warehouse management server (the server on which you ran Setup), run services.msc, and verify that the following services have been installed:
System Center Data Access Service
System Center Management
Note
For System Center 2012 R2 Service Manager, the System Center Management service was renamed to Microsoft Monitoring Agent.
System Center Management configuration
On the computer that is hosting the data warehouse databases, click Start, point to Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
In the Connect to Server dialog box, select the following:
In the Server Type list, select Database Engine.
In the Server Name list, select the server and instance for your Service Manager data warehouse database. For example, select Computer 4.
In the Authentication list, select Windows Authentication, and then click Connect.
In the Object Explorer pane, expand Databases.
Verify that the DWDataMart, DWRepository, and DWStagingAndConfig databases are listed.
-----
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----