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:
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:
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…
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
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.