Windows Server

Service Manager 2012 Beta: Installing the Data Warehouse Server

In the first two parts of this series, we covered what System Center Service Manager 2012 has to offer and what the SCSM System Requirements entail as well as the complete step-by-step instructions for installing the Service Management Server, with the end result being a fully operational Service Manager 2012 beta infrastructure.

Today we will focus on installing the Service Manager Data Warehouse Server. This role will be configured on a separate virtual machine in our environment. According to Microsoft’s best practices, the Data Warehouse Server should not reside on the same server as the Management Server, so we’ll follow the guidelines by installing it on a separate VM. After we successfully install the Data Warehouse Server, we will configure the Data Warehouse Connection from the Service Manager management server console.

In future articles in this series we’ll take a look at:

Installing the Service Manager Data Warehouse Server

Start by opening the Service Manager Setup Wizard and selecting “Install a Service Manager data warehouse management server.”

Sponsored Content

What is “Inside Microsoft Teams”?

“Inside Microsoft Teams” is a webcast series, now in Season 4 for IT pros hosted by Microsoft Product Manager, Stephen Rose. Stephen & his guests comprised of customers, partners, and real-world experts share best practices of planning, deploying, adopting, managing, and securing Teams. You can watch any episode at your convenience, find resources, blogs, reviews of accessories certified for Teams, bonus clips, and information regarding upcoming live broadcasts. Our next episode, “Polaris Inc., and Microsoft Teams- Reinventing how we work and play” will be airing on Oct. 28th from 10-11am PST.

Install a Service Manager data warehouse management server

Figure 1: Install a Service Manager data warehouse management server

Step 1: Enter the Name and Organization and click Next.

Data Warehouse Server Product Registration

Figure 2: Data Warehouse Server Product Registration

Step 2: Confirm the suggested program file location or choose a specific one and click Next

Service Manger 2012 Installation location

Figure 3: Installation location

Step 3: Confirm the prerequisites (we’ll ignore the warnings in our scenario) and confirm by clicking Next

Data Warehosue Prerequisites

Figure 4: Data Warehosue Prerequisites

Step 4: This next window required some attention. Here you’ll need to enter the SQL Server and Service Manager instance. Make sure you verify the details for each component:

–          Staging and configuration

–          Repository

–          Data Mart

Configure the data warehouse databases

Figure 5: Configure the data warehouse databases

Otherwise, you will get an error, as shown in Figure 6 below

Error when configuring data warehouse databases

Figure 6: Error when configuring data warehouse databases

Once all database server and instance information is entered for the 3 options, confirm by clicking Next

Configuring additional data warehouse datamarts

Figure 7: Configuring additional data warehouse datamarts

Step 5: Next, choose a descriptive but unique name for the Data Warehouse Management Group. This name should be different from the Management Group Name you chose while installing the Service Manager Management Server. Confirm with Next.

Configuring the data warehouse management group

Figure 8: Configuring the data warehouse management group

Error configuring the reporting server for the Data Warehouse server

Figure 9: Error configuring the reporting server for the Data Warehouse server

In the above setup step, we are facing an issue where the SSL trusted connection to the SQL server is not possible. The easy solution for this is exporting the SQL server’s server certificate and importing this certificate on our Service Manager Data Warehouse Server, as explained in the following steps:

  • Logon to the SQL server (Alexander in our scenario), / Start / Run / MMC / Add Snap-In / Certificates
  • Select the server certificate / Export wizard / Make sure you save it as a PFX-file
  • Enter a password to “encrypt” the certificate file
  • Logon to the Service Manager Data Warehouse, and import the SQL server certificate into the trusted certificate store
  • Start / Run / MMC / Add snap-in / Certificates / Import

 

Here are the screenshots to help illustrate these steps:

Certificate Import Wizard: Confirm with Next

Figure 10: Certificate Import Wizard: Confirm with Next

Select the previously exported PFX-file

Figure 11: Select the previously exported PFX-file

 

Confirm with Next

Figure 12: Confirm with Next

Enter the previously chosen Password during the export process

Figure 13: Enter the previously chosen Password during the export process

 

Make sure you select the Trusted Root Certification Authorities certificate store

Figure 14: Make sure you select the Trusted Root Certification Authorities certificate store. Confirm with Next.

Confirm with Finish.

Figure 15: Confirm with Finish.

Validate the SQL Server certificate is visible under the Trusted Root Certification Authorities certificate store.

Figure 16: Validate the SQL Server certificate is visible under the Trusted Root Certification Authorities certificate store.

Once this is done, we can return to the SCSM Data Warehouse setup, and retry the SQL connection.

Step 6: As there is no “retry” button, we’ll select Previous and Next in the Setup Wizard; this will restart the SQL server connection, which now should be successful. Confirm with Next

Configuring the reporting server for the data warehouse

Figure 17: Configuring the reporting server for the data warehouse

Step 7: Confirm the details  and click Next.

Configuring the reporting server with success

Figure 18: Configuring the reporting server with success

Step 8: Enter the Service Manager service account information (scsmadm in our scenario) and click Next.

Configure the account for Service Manager services

Figure 19: Configure the account for Service Manager services

Step 9: Next we enter the Service Manager reporting account details. In our scenario, we have chosen the same service account as the service manager server; in a production environment however, you could choose a specific service account for this.

 

Configuring the Service Manager reporting account

Figure 20: Configuring the Service Manager reporting account

Step 10: Enter the required information to configure analysis services for Online Analytical Processing (OLAP) and click Next.

Configuring Analysis Services for OLAP cubes

Figure 21: Configuring Analysis Services for OLAP cubes

Step 11: Enter the required credentials anc click Next.

 

 Configuring Analysis Services credentials

Figure 22: Configuring Analysis Services credentials

Step 12: Select whehter you’d like to participage in Microsoft’s Customer Experience Improvement Program and confirm with Next

Help Improve System Center Service Manager

Figure 23: Help Improve System Center Service Manager

Step 13: Select  whether you’d like to use Microsoft Update and confirm with Next.

Use Microsoft Updates

Figure 24: Use Microsoft Updates

Step 14: Verify your installation summary and confirm by clicking Install

Service Manager Installation Summary

Figure 25: Service Manager Installation Summary

Step 15: This summarizes the installation of the Data Warehouse components; if all is successful, every option will be flagged in green as shows in Figure 26.

Setup completed

Figure 26: Setup completed

Once the installation is complete, we are faced with the encryption key backup process, which is similar to the steps we performed when installing the Service Manager Management Server  <link: https://petri.com/system-center-service-manager-2012-installation.htm>

This concludes the installation of the Data Warehouse server components. In the next section we will configure the Data Warehouse Connection from within the Service Manager management server console.

Configuring the Data Warehouse Connection

Now both the Service Manager Management Server and the Data Warehouse Server are up-and-running, we will conclude the configuration by registering the Data Warehouse server.

Step 1: Open the Service Manager management server console and s elect Register with Service Manager’s Data Warehouse option

Service Manager Management Server Console

Figure 27: Service Manager Management Server Console

Step 2: Once the Data Warehouse Registration Wizard launches, choose Next to continue

Data Warehouse Registration Wizard

Figure 28: Data Warehouse Registration Wizard

Step 3: Select your Data Warehouse Server name and click Test connection then click Next to confirm.

 Specify the data warehouse management server name

Figure 29: Specify the data warehouse management server name

Step 4: Select the specific Data Warehouse service account (Figure 30) that you created  and configured during the Data Warehouse installation steps above. Enter in your credentials (Figure 31).

Data Warehouse Account

Figure 30: Data Warehouse Account

Figure 31: Data warehouse credentials

Step 5: Click close to complete the configuration wizard

 Conclusion

This concludes the registration with the Data Warehouse Server. Now you have a successfully running Data Warehouse Server as part of your System Center Service Manager 2012 beta environment.

The next article in this series will cover the configuration of the System Center Configuration Manager 2007 R3 Connector.

Related Topics:

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by:

 
Office 365 Coexistence for Mergers & Acquisitions: Don’t Panic! Make it SimpleLive Webinar on Tuesday, November 16, 2021 @ 1 pm ET

In this session, Microsoft MVPs Steve Goodman and Mike Weaver, and tenant migration expert Rich Dean, will cover the four most common steps toward Office 365 coexistence and explain the simplest route to project success.

  • Directory Sync/GAL Sync – How to prepare for access and awareness
  • Calendar Sharing – How to retrieve a user’s shared calendar, or a room’s free time
  • Email Routing – How to guarantee email is routed to the active mailbox before and after migration
  • Domain Sharing – How to accommodate both original and new SMTP domains at every stage

Aimed at IT Admins, Infrastructure Engineers and Project Managers, this session outlines both technical and project management considerations – giving you a great head start when faced with a tenant migration.the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

Sponsored by: