By Bill Ramos Principal Program Manager, SQL Server Manageability
In this blog post, I will go over the steps to install System Center Operations Manager (SCOM) 2007 R2 and the recent release of the SQL Server 2008 R2 Management Pack (MP) on a bare bones Windows Server 2008 R2 Hyper-V virtual machine. I’ll include where you can download the various software components (free & evaluation copies). My goal is to make operational DBAs familiar with SCOM 2007 and the various MPs that are available to help you better manage large number of server instances.
This blog post is part of the series of posts that I’m using to prepare for my SQL PASS 2010 session on the SQL MP.
I’m starting with a Windows Server 2008 R2 Hyper-V image with 4GB of RAM and 1 virtual CPU. This configuration is the minimum recommended configuration for all of the SCOM 2007 R2 features.
There is always something out there that needs to get updated after installing Windows Server 2008 R2. Be sure to check for updates as part of your Initial Configuration Tasks as shown below.
Generally, you will need to reboot after this step to make sure Windows Server 2008 R2 didn’t have more updates that require a reboot. Just reboot to be on the safe side.
After the reboot, you will need to add the IIS role to your server. Just click on the “Add roles” command shown above in the “Customize This Server” section of the Initial Configuration Tasks dialog. This will launch the Add Roles Wizard. At this point, I’m assuming you are logged into the server with a Windows login that is a system administrator for the machine.
Just click Next past the introduction page. You will then select the Web Server (IIS) role as shown below.
Then click Next. The wizard will then take you to the “Introduction to Web Server (IIS)” page. You are welcome to read the page and click on the hyperlinks to read more about IIS, but we are focusing our attention on getting SCOM up and running. So, click Next to move along.
The Role Services dialog is the tricky one since you need just about all of the services selected to pass the prerequisite checks for SCOM. So, select all of the check boxes to be on the safe side. At some point, I’ll follow up with a blog post on what you can disable. See below for what the Role Services page should look like before selecting the Next command.
Once you have selected every service – click Next to go to the Confirmation page and then click Install. With any luck, you should get to the Results page indicating “Installation succeeded”.
Go ahead and click the close button for the Add Roles wizard. Time for a quick test to see if IIS installed. go ahead and launch IE 8. If you are running with Enhanced Security Configuration, we’ll deal with that in a moment since you’ll need to download more software from the web.
In the IE8 address bar, type http://localhost. If all went well, you should see the following:
Go ahead and close the browser for now. You can also close the Initial Configuration Tasks dialog and you might want to check the box that says, “Do not show this window at login”.
As soon as the dialog closes, Windows Server 2008 R2 launches the Server Manager. At this point, let’s reconfigure “Configure IE ESC” so that you can browse the web without the annoying prompts. NOTE: It is Microsoft’s recommendation to have this feature on for production servers,, but we are just trying to get things spun up the first time with ease. So, be sure to turn ESC back on once everything is running well for you.
Go ahead and click on the Configure IE ESC link as shown below.
Then select Off for both Administrators and Users as shown below and click OK.
There is one more add-on that you must install called ASP.NET AJAX 1.0 that you can download from here. It’s also listed in the download links below. Just click on the Download button on the web site and run through the installation taking all of the defaults.
I’m taking a gamble here since support for using SQL Server 2008 R2 was just announced on September 25, 2010 as part of a “FAST PUBLUSH” knowledge base article – see Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database. You don’t really need to check out KB Article 2425714 since I’ll guide you through the basics later on.
I’ll assume that you have access to the installation files for SQL Server 2008 R2. Check out the download links at the end of this posting for getting an evaluation copy. I recommend going with an Enterprise SKU since it has some cool features like row level compression for your database tables that can save you up to 20% or more disk space with a little more overhead on CPU. There are other great scalability features you can check out at the MSDN article titled Features Supported by the Editions of SQL Server 2008 R2.
Go to your installation folder and the click on Setup.exe. This displays the SQL Server Installation Center as shown below. You’ll want to select the Installation page.
Then select the hyperlink for New installation or add features to an existing installation as shown below.
I’m not going to run through all of the installation screens, but here are the basics to get you up and running. To keep things simple, I’ll assume you will use a Windows domain account with system administration permissions for all of the SQL Server services. I know this is not recommended, and you can change to lower privileged accounts once everything is working.
With any luck, setup would have gone without a hitch and you can close down the SQL Server Installation Center dialog.
If you want to author your own Management Packs, you need to install as a minimum Microsoft Word. SCOM 2007 R2 will work with older versions of MS Word, but this is a new box, so you might as well install all of Office. At least, you no longer need Outlook to send emails with SQL Server. NOTE: You will need to install the 32-bit version of Office for this all to work correctly. SCOM uses the Visual Studio Tools for Office runtime which is a 32 bit tool and only works with 32 bit versions of Office at the time of this blog posting.
Go ahead and just install with the default “Big Button” install option – Install Now.
Note – Before you do anything, make sure you didn’t skip Step 1.5 above. If you forgot, the installation process will politely remind you that you needed to install the ASP.NET AJAX component.
Go to your installation location for System Center Operations Manager R2 release and run OPSMGR2007R2SEL.exe from your local disk. This file is a self extracting zip file with all the components needed to install SCOM 2007 R2.
When you run the .exe file, you should see the following message box kicking off the installation process.
Followed by the WinZip Self-Extractor UI.
Click the Unzip bottom. At the end of the unzipping process, you should get a message box indicating that 243 file(s) unzipped successfully. Once you click OK, the System Center operations Manager 2007 R2 Setup will be displayed. You may find it hidden behind another window. It looks like this:
Click on the Browse this CD because we need to “manually” run the DBCreateWizard command that is located in the SupportTools\AMD64 folder as shown below.
Here are the relevant instructions from the the article “Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database”.
Note You must run the DBCreateWizard tool on the server that is running SQL Server 2008 R2.
938997 (http://support.microsoft.com/kb/938997/ ) Operations Manager 2007 Support Tools requirements
If everything went according to plan, you will get a message box indicating that the “Database created successfully” and click OK.
Now comes the tricky part because we don’t want to install the Database components at this time as per the article “Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database”. This article neglects to tell you how not to install the Database components. Starting from the figure below:
Click on the icon drop down control next to the word Database as highlighted above.
Choose the command “This component will not be available.”. Once you’ve selected the command, the dialog should look like this:
If life is treating you fairly, the installation should complete and display the following dialog.
You don’t want to Start the Console quite yet, but you do want to backup the Encryption Key when you Finish the wizard. just follow the steps for backing up the key to a box off-site from the original machine. The instructions in the wizard are straightforward.
Note You must follow these steps on the SQL Server Reporting Services server.
Important When you install System Center Operations Manager 2007 R2 Reporting, you should not install the Data Warehouse component. See below image for not installing the DW component. The installation process is very similar to installing the main SCOM 2007 tools, so I’ll skip the dialogs. Again, when you get to the “Operational Data Reports” wizard page, please select Yes, send operational data reports to Microsoft.
Supported configurations for System Center Operations Manager 2007 R2 For more information about supported configurations for Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database, visit the following Microsoft Website: http://technet.microsoft.com/en-us/library/bb309428.aspx
You can now Exit the SCOM 2007 R2 installation program
Go to the download center for the free SQL Server MP at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8c0f970e-c653-4c15-9e51-6a6cadfca363&displaylang=en
The files are simply downloaded to the install location, you now need to import the MP files into the SCOM Operations Console.
Are the “go to” links to download evaluation copies of the software described in this blog post.
As I continue to prepare for my SQL PASS session on the new SCOM MP for SQL Server, I’ll continue blogging – especially examples with using the new SQL Server 2008 R2 Monitoring MP. I will also cover how the data collection with SCOM 2007 R2 can be used in conjunction with the SQL Server 2008 Data Collector and Management Data Warehouse and the SQL Server 2008 R2 manageability tools.
Please feel free to add a comment to the blog post and don’t forget to rate it!
Great post -- very detailed and nicely written. Thanks
Thanks Bill! I just ran through these great steps and have it all running on my test machine.
Great post nice, work for me, thanks !!!!