Posts Tagged ‘SQL’

So, recently I decided to take the plunge and upgrade to SCOM 2012. So, there were a few pre-requisites that I needed as per the prereq checker that is built into OpsMan 2012.

The “big ones” were as follows.

1. OpsMan 2007 R2 CU5

2. And FTS (Full Text Search) for SQL.

So, these seem easy enough to fix.

1. Simple download Cumulative Update 5 for System Center Operations Manager 2007 R2 and install. To be honest, I found this article super helpful for the installation of this Cumulative Update, nice and easy to follow. Kudos to Kevin Holman. So after running through the process step by step, I found that the build number had NOT increased to 6.1.7221.81. Very strange indeed. This needed some more investigation, but more on that just now.

2. Simple go and add this feature to your SQL instance, not very difficult to, so I simply walk through the wizard and add the feature.

So, now time to run the Pre-Req checker again, and what do you know the Cumulative Update 5 is NO LONGER showing (but remember the build version in the console is NOT reflecting the correct build number. Also, the FTS (Full Text Search) requirement is still there and I am have installed the FTS feature.


However as you can see below.


Very strange indeed, so like I said some further investigation is required.

I remember being at some Microsoft IT Bootcamps, and the continued emphasis on SQL Collation and OpsMan in general. So I decided to check this. My Version below.


As per this TechNet Article, the only supported collation for English is SQL_Latin1_General_CP1_CI_AS. Oh oops!

Never fear though, his can be fixed, however the articles must be followed very carefully and within a reasonable amount of time as while you are doing this whole process, your OperationsManager and OperationsManagerDW databases will not be collecting all of the information all of the time. So, there WILL be some (very minimal) data loss in terms of agents reporting into the Management Group.

All the articles are TechNet Articles, see below.

How to Move the OperationsManager Database in Operations Manager 2007

How to Move the OperationsManagerDW Database in Operations Manager 2007

How to Move the Operations Manager Reporting Server in Operations Manager 2007

Once, I had made my way through all the articles, I tried my original steps again and this time, without any issues, I was able to install Cumulative Update 5 for System Center Operations Manager 2007 R2 and successfully able to get the pre-req checker to list all pre-reqs met.

Follow me.




Do you ever have those days where it just starts bad and gets worse?

“Man Alive, what a day it has been and it is not over yet”

First, simple network change, enabling DHCP helper on our new Infrastructure. Sounds simple, right?. Well, our switches are stacked for connectivity and storage, so a reboot of the switches means shutting down the environment, IP and iSCSI. So I go and do this, not knowing about our cluster needing 3 nodes active, what a mission. We eventually got everything up and working after some help from “Call a Friend”, you know who you are and THANK YOU AGAIN Smile.

Then we decide to move one and continue the day’s work with our migration, hit some snags there, but got through that.

Got to my desk and decided to load up our helpdesk tool, only to find the Reporting component is playing up. However, I would like to introduce all of you to my good friend and you all know him, Uncle GOOGLE. After much digging through MS Articles and already having done these steps and not finding much wrong, I came across the following gem. . Gotta love these dedicated sites, followed the TEMP folder route and “voila” (almost as good as abracadabra, hehe), it is now working again.


In hindsight, should have stayed in bed and bunked today.