Thus far, we have covered the following in relation to Service Manager 2010 Beta 2:

  • What components are necessary for installing Service Manager
  • Understanding hardware / software / OS requirements
  • Service Manager build out scenarios
  • Service Manager Data Warehouse Database
  • Installing the components of Service Manager

Continuing on with the focus on Service Manager 2010 Beta 2, this posting will walk you through the install of the Service Manager Data Warehouse Database.

Please note that I will not cover SSRS in this posting, but you can reference the installation here.

During the install of the Service Manager DW and DB, you will be prompted for the following:

  • Management Group Administrator
  • Service Manager Account Services account
  • Reporting Account

Accounts Used During the Installation of a Service Manager Management Server:

(click to enlarge)

During the setup Service Manager checks the server you are logged onto to see if it can host the data warehouse databases.

In my lab I tried to install the Service Manager Data Warehouse (separate instance) on the same server running the Service Manager Database — I wasn’t able to install to the separate SQL instance as the Service Manager DW install saw that there was already an installation of Service Manager installed.

Walk through of the Service Manager Data Warehouse Database installation:

***Leave the Product Key empty — isn’t necessary for beta installs.

Browse to a different install location if necessary.

Even though it reports a warning for memory/processor, you can continue…

As previously noted, there are three databases that comprise the Service Manager Data Warehouse Databases:

  • Data Warehouse Configuration Database (DWStagingAndConfig)
  • Data Warehouse Repository Database (DWRepository)
  • Data Warehouse Data Mart (DWDataMart)

The Data Warehouse Configuration Database and Data Warehouse Repository Database must reside on the same SQL Server. The Data Warehouse Data Mart can reside on a separate SQL Server.

In my lab all three databases reside on the same VM…

Service Manager DW Staging and Configuration Database

Service Manager DW Repository Database

Service Manager DW Data Mart Database

The next step will be to configure the Data Warehouse Management Group.

You will be prompted to enter a Management Group Name — type a unique name for the group name.

“Management group names must be unique, even the names used for the Service Manager management server and data warehouse management server.” – Microsoft

Enter a unique name different from any other management group in Service Manager.
Browse to select the Management Group Administrators you created prior to the installation.

Enter the account for Service Manager Services; verify credentials.

Enter the reporting account created prior to the installation; verify credentials.

Select “Yes” here so that the Service Manager Product team can get (valuable) feedback for your experiences.

List of items completed during installation of Service Manager.

Service Manager setup completed successfully.

Upon launching the Service Manager, you will now see an option to view the Database and Reporting…

We are not done just yet…

Next we’ll Register with Service Manager’s Data Warehouse.