As we discussed – in Part 1: Installing Management Server and Database – the Data Warehouse Server cannot reside on the same server as the Management Server. The installation process is fairly simple (but lengthy, I snoozed at the end of it). you need to get SQL up and running, then have the server installed.
Installing SQL Server 2008 R2 SP1
You can follow the same steps as in installing the Management Server except for the Database in the feature selection you need to add Reporting Services and Analysis Service (don’t forget the Full Text Search)
once you have them ready proceed with the server installation
Installing the Data Warehouse Server
Have you Windows Server 2008 R2 SP1 installed (yes SP1 with SCSM 2012), install the following prerequisites on the server:
1. .Net Framework 3.5 SP1 (from the Server Features)
2. PowerShell 2.0 (already installed)
Put in the installation media and choose the option to install the Data Warehouse Server
Enter your name, organization and accept EULA, leave the prerequisites checker for a while
Now for the Dataware House Databases configuration page, the famous SQL collation warning will be displayed, then you can configure each database individually by clicking on its name
Now you can configure the Data Mart databases (DMs), these are the accessible layer of the warehouse we’re setting up
The Management Group Name for the Dataware House server is different from the one for the Management Server, again, it should be unique in the organization and among any Management Group that has ever crossed your life (yes, unique among Operations Manager too)
as for the Group Admins, same as I stated in the Management Server setup, create one, add the current use to it, make the group a local server admin, then proceed.
Configure the SSRS server to be used for the Data Warehouse reports (side: don’t you think if the product team should’ve used an FQDN? what’s up with the drop down menu? not so flexible)
Now type in the Service Account to be used who is also a local Administrator on the Data Warehouse Server, in this case, using the Local System account isn’t appropriate at it, because the service here needs to access our Management Server.
Same thing for the Reporting account, to be used to read some data from the warehouse, except it doesn’t really need to be an Local Admin and it doesn’t need to be granted the Run As a Service right.
Type the name for the OLAP Database, and press next
I’m really really sleepy by now.. that’s a lot of Wizard Pages!! I’ll snooze n get back to ya..
Okay, lets get back to the wizard, we need to enter the credentials for the Analysis Services account, again it’s a Service Account (make it local admin),
notice that the Product Team decided not to provide any kind of description here…
Now the setup will ask you about CEIP, Updates, and Settings Review, and actually BEGIN installing
Thank you for staying with this up until this moment, if you can read this line this means you’re still awake.