System Center Operations Manager by Jonathan Hambrook

July 2, 2007

SQL 2000 showing as ‘Not monitored’

Filed under: Microsoft, SCOM 2007 — opsmgr @ 10:13 pm

A common question asked in a lot of forums is why is SQL 2000 showing as ‘Not monitored’ even though I have the Management Pack installed.

SQL 2000 Not Monitored

Well as it says, its not being monitored. This doesn’t mean that you can’t it is simply that the rule that is used to monitor this object is currently not enabled. A quick one for all the newbies to SCOM, you aren’t just able to find the rule and click enable like in MOM 2005. However I would suggest you plan this as the design in SCOM 07 is to have you create overrides. This will require the use of a Management Pack which out of the box there is just the one that you can use which is the ‘Default Management Pack’.

Here is a quick step by step on how to enable the SQL 2000 Monitoring. Note: This can be used for any MP but SQL seems to be the most commonly asked as most of us would assume installing the MP would just work.

1. Open the Operations Manager Console and go to Authoring

2. Select Monitors under Management Pack Objects

3. To make it easy to locate the right Monitor change the scope to look at just SQL 2000 DB Engine

4. Expand Availability

SQL 2000 DB Availability

5. Right click on the SQL DB Engine Service Health Rollup and select Overrides -> Override the Monitor -> For all object type: SQL 2000 DB Engine. (You will notice that enable is greyed out, this because this MP is locked. We will be creating an override in a new MP. Also not the light greyed area in the above screen-shot, this is due to the the fact I used the search feature to find the exact Rule quickly using the word Health so each Rule with Health in it shows in Black.)

6. As per the screen shot, Tick the Override box next to Parameter you want to change and in the Override Setting change the field to the appropriate setting. For full functionality you can tick them all and if that’s too much you can scale back.

7. Select the Management Pack you would like to create this override in, I have an SQL Override Management Pack where I store all the SQL Overrides in. This I find makes it easy to track down in the feature, you are also then able to run a report against that Management Pack to get a list off the rules it contains.

SQL 2000 Override Settings

8. Click OK. In most cases you will need wait for the Agents to update but if you are impatient, just stop and restart the Health Service on the SQL 2000 server you are monitoring.

SQL 2000 DB Availablity OK


June 30, 2007

Hardware Monitoring with SCOM 2007

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 3:30 pm

UPDATE — Looks like the Major 3 server hardware manufactures have now all released their Management Packs see the list below.

I work with most of the popular and even some un-popular providers and as such I will use this post to direct you to where you can get the latest hardware Management Packs:

 – Server & Blade Center: (You will need to log in. You will find the downloads at the bottom of the Windows pages. See screen Shot)
IBM Management Pack Download

– Server:

– Server:
– Storage Works:

Note: I have spoken to reps and have been told that the Management Pack for Acer Server will be out Q3 2007. This work has been outsourced to Microsoft to develop.

June 28, 2007

Web Console Error: “Server Error in ‘/’ Application – Requested value ‘UrlViewType’ was not found.”

Filed under: Errors, Microsoft, SCOM 2007 — opsmgr @ 9:19 pm


You get the following error in the SCOM Web Console:

Server Error in ‘/’ Application – Requested value ‘UrlViewType’ was not found.


This is due to the fact that Microsoft doesn’t support Web Page Views in the web console.


Remove the Web Page View or don’t use the Web Console.
 I believe MS are working on a fix for this.

Custom created Management Pack with custom rules don’t show correctly in Reporting

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 8:59 pm

I have found the following Issue when creating a report from a Custom Performance Counter that was added to a Custom Management Pack.

If you would like to follow along, First, create a new Management Pack and then under Authoring create a Rule for a performance counter ie: % Processor Time.

Second, go to Reporting and under “Microsoft Generic Report Library” open the “Performance” report and fill out all the details. When you go to selecting the counter you will see an uninterperatable name. This is displayed as a sequence of numbers and letters where the counter name should be, this is obvious from the screenshot below:

Rule Name Not Showing correctly in SCOM Reporting

This becomes a real neusence when you get your report results as the ‘Rule:’ detail is not interperatable. So should you forget what you printed or saved, you will not be able to reference this in the feature. See the follow screenshot:

Performance Rule Unreadable Rule Name

I have highlighted where you should see what the counter name is, if you were to look back at this report in the future you would not be able to tell that it was % Processor Time.

Duplication in Reports – Issue found in SQL MP

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 8:48 pm

I have found a issue I have yet to verify with other Management Packs but will be doing some testing to see how common this is.

Basicly, if you install the SQL Management Pack and then Uninstall it and then reinstall it again, and in my case it was off for about 2 weeks. You may find when in the Monitoring pane that when you are highlighting an SQL server under Microsoft SQL Server – Active Alerts you see duplicate reports. See the screenshot below:

Duplicate SQL Reports

June 26, 2007

‘Design a report’ in SCOM Reporting fails to open successfully

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 2:49 pm


 When in the Reporting pane of System Center Operations Manager, you click on ‘Design a report’ and IE opens and then closes straight away with no error.


This is caused by the requirements of Microsoft’s ClickOnce technology not having the required IE setting configured. The minimum requirements can be found at

In summary of the article you need to enable to following configuration in IE’s Internet Option enabled:

.NET Framework-Reliant components
         – Run components not signed with Authenticode


  1. Open IE 7
  2. Click on Tools / Internet Options
  3. Select the Security Tab
  4. Select the zone ie: Local Intranet
  5. Click Custom Level…
  6. Find .NET Framework-relient components and enable the Run components not signed with Authenticode
  7. Apply and close IE

If your like me and have a Group Policy setting these settings, you will need to create a new Group Policy and import the IE Group Policy Template. This is located normaly in Windows\inf folder called inetres.adm.

Import this into an overwriting policy for the machines that require this setting.

June 20, 2007

Finding a MP Rule

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 7:08 pm

I have found and also reading a lot of posts in message boards that one of the big changes in moving from MOM 2005 to SCOM 2007 is where do MP rules go and how can i view them and disable or edit them. So here is a quick few steps to help you out:

1. Open the Operation Console
2. Open the Authoring section
3. Expand Management Pack Objects and click Rules
4. There is light yellow line which operates the Scope function
5. Click Change Scope
6. Now select the targets you are interested in viewing. (These are name very similar to the MP’s you have installed)
7. Click OK
8. Now you can Right-Click and perform the required override or view the rule properties.

Its good to note that most packaged MP’s are now ‘locked’ which means you will only be able to perform a limited set of functions on them. Bacause of this you are also not able to create new rules in a locked MP. Microsoft have you create your own MP and create all your new task and rules. So be sure to try and keep a standard when creating new MP’s as it will make management a lot easier.

Operations Manager 2007 Design Guide Released

Filed under: Microsoft, News, SCOM 2007 — opsmgr @ 2:38 pm

What I would believe to be a document needing to be released before the product, the Design Guide, has now been published on the Microsoft Website. Authored by Christoper Fox its a nice read for those Architects out there planning a SCOM deployment.

My only opinion at the moment on the data contained is I believe the minimum are too low. If your like me and like speed then I would recommend much higher configurations.

You can get a copy of the Design Guide from the link bellow:

June 19, 2007

SRS Server Validation Error – (407) Proxy Authentication Required

Filed under: Errors, Issues, Microsoft, SCOM 2007 — opsmgr @ 3:12 pm


If like me, you are behind a proxy and you use a proxy.pac file to athenticate to the Internet, and you have this set in IE. You may get an SRS Server Validation Error. To find out if this is the case use the following command line to log the instalation of the SCOM Reporting MSI:

msiexec /i reporting2007.msi /l*v c:\reportinglog.txt

Look at the reportinglog.txt file and you will see the following:

Action start 12:25:05: _ValidateSRSWebSiteBindingsCA_Wizard.
MSI (c) (58:44) [12:25:05:568]: Invoking remote custom action. DLL: C:\DOCUME~1\itsjrh\LOCALS~1\Temp\MSI2C2.tmp, Entrypoint: ValidateSRSWebSiteBindingsCA
MSI (c) (58!E4) [12:25:06:146]: PROPERTY CHANGE: Adding REPORT_SERVER_FULL_HTTP_PATH_VALID property. Its value is ‘0’.
MSI (c) (58!E4) [12:25:12:787]: PROPERTY CHANGE: Adding FailedMsgProperty property. Its value is ‘CheckHttpAddressResponse: Failed Status Code of The remote server returned an error: (407) Proxy Authentication Required.’.


Remove all proxy setting from IE and re-run Reporting installation.

June 18, 2007

Backout / Roll Back a SCOM Management Pack

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 4:00 pm

It would be nice if SCOM supported a Roll Back feature for its Management Packs like Windows does with drivers nowadays. However it doesn’t, so should you want to backout an MP you are going to need to remove it. You are unable to install an older version MP over a new version MP.

Removing a SCOM Management Pack is simple:
1. Open System Center Operations Manager 2007 Operators Console
2. Go in to the Administration section
3. Select the Management Packs in the left plane
4. Highlight the Management Pack you with to remove on the right
5. Right-Click and select Delete
6. Click YES to approve

Note: Some MP’s (ie: SQL) have dependancies and these will be shown as needing to be removed before you can remove the currently selected MP.

Once you have clicked delete it can take some time and you will notice that the TEMPDB in your Database Warehouse can expand to an incredible amount. I have seen it get upto 14GB! This something to keep your eye on as you will be removing all the data associated with the Management Pack.

June 12, 2007

Back from Holidays! 12th June

Filed under: News — opsmgr @ 3:02 pm


I am back from holidays and have started to get back into things and have a lot of interesting emails from various sources including Microsoft with updates and issues with SCOM.

I had a great holiday in the US visiting LA, San Fransisco, Chicago and New York with a 3 day stop over in Fiji on the way back. The people were great but as I went there to visit friends I can’t say I saw as much as a tourist would. Have to say though that with no expectation of Chicago it exceeded all expectations and has jump to the top my favorite places in America 🙂

However, with my hobby being in Wine I did enjoy the Nappa thoroughly!

Look forward to getting back into SCOM and posting some good fixes and topics soon

May 24, 2007

On Holiday till June 11th ’07

Filed under: News — opsmgr @ 11:23 am

I am fly out of Australia for the US for 2 weeks untill the 11th of June and as much as I would love to keep posting and working on new blog postings I am unable to take my SCOM environment with me 🙂

However when I return I will be fresh, hopefuly stress free and full of energy to keep working on the massive world of SCOM!

May 21, 2007

How to record a browser session in SCOM 07

Filed under: Microsoft, SCOM 2007 — opsmgr @ 4:43 pm

This is a quick post due to a few questions about where you can record a browser session.

First thing to note is that you need SCOM installed and IE7 as a minimum. This can be on the RMS or preferably your own PC. If you are installing IE7 ensure you reboot the machine after this before you continue as there are a few known issues that arrise when havnt rebooted.

If your the kind of noisy person that like to see exactly where apps are installed and intergrated like I do, you will see that in IE7 under Tools -> Toolbars -> Explorer Bar you will see Web Recorder. While you can see it you need to run it through System Center Operations Manager which I will details now:

1. Open System Center Operations Manager
2. Go to Authoring
3. Under Management Pack Templates select Web Application.
4. You can now either click on Actions or in the Actions tab you will see a new section called Custom Actions from either click Record a browser session.

As for using it, well thats the easy part! Just follow the wizard and select the Watcher Nodes!

May 17, 2007

Error 0x8004005: Unspecified Error

Filed under: Errors, Microsoft, SCOM 2007 — opsmgr @ 2:36 pm


You deploy an agent from the Management Server and in the pop-up deployment windows its listed as Successful however the server remains in Pending Management listed as ‘Install in Progress’.

The OpsMgr Health service fails to start and returns the following error: Error 0x8004005: Unspecified Error


This is caused by the Management Group changing and no longer being contactable but with the agent still being deployed and you try to install over the top into a new Management Group.

You will see the following error when you try to start the OpsMgr Health service:

Error 0×80004005: Unspecified error

You will also see the following error listed in the Event Viewer of the destination server:

Event Viewer Error 7023

If you the ablity to run a TraceLogSM and get it analised by Microsoft you will see a log similar to bellow. Not the hightlighted sections show the domain, service account and Management Group. If any of there are incorrect then you have found the issue.

You will need to run the TraceLogSM with the follow parameters:
TraceLogSM -start HSCORE -f hscore.etl -b 8 -ft 30 -guid #417B7AE0-9B8F-4E3F-8FCA-19C706EFF3D4 -flag 0xF -cir 100

To stop use: TraceLogSM -x

Send the file hscore.etl to Microsft for analysis.

67     HealthServiceCommon  23900  8856   2      0      05\17\2007-11:04:12:399    Logging informational event with args MGROUP
68     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:430    SSRef 63745834-3e54-936c-1b47-2d632054a177 resolves to 00BD5E70CBE8C70C8ABA7F843EB0BB42BA1920A05C00000000000000000000000000000000000000 : 0(ERROR_SUCCESS)
69     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Account QBEAU\SCOM_AAA logged on : 1(ERROR_INVALID_FUNCTION)
70     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Unable to create logon token : 1(ERROR_INVALID_FUNCTION)
71     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Unable to log on user : 1(ERROR_INVALID_FUNCTION)
72     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Unable to log on account : 1(ERROR_INVALID_FUNCTION)
73     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Unable to retrieve the action account reference : 1(ERROR_INVALID_FUNCTION)
74     SecureStorageManager 23900  8856   2      0      05\17\2007-11:04:12:446    Unable to add store to store hashtable : 1
75     ConnectorManager     23900  8856   2      0      05\17\2007-11:04:12:446    Secure Storage Manager failed during MG notification : -2147467259(E_FAIL)
76     ConnectorManager     23900  8856   2      0      05\17\2007-11:04:12:446    Unable to inform components about management groups : -2147467259(E_FAIL)
77     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:446    Start of 1 manager failed with code -2147467259(E_FAIL).
78     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:446    ManagerStartup failed with code -2147467259(E_FAIL).
79     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:446       ServiceInitialization failed with code -2147467259(E_FAIL).
80     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:446    Health service is stopping.
81     HealthServiceCommon  23900  8856   1      0      05\17\2007-11:04:12:446    “Logging success event with args DOMAIN1, SCOM_AAA, MGROUP
82     HealthServiceHost    23900  22684  1      0      05\17\2007-11:04:12:868    HealthService.exe exiting.
83     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:868    Health service entered the stopped state.
84     HealthServiceExecutive     23900  8856   2      0      05\17\2007-11:04:12:868    Start failed with code -2147467259(E_FAIL).
85     ConnectorManager     23900  15272  3      0      05\17\2007-11:04:12:868    GetHealthStatus called after service shutdown.
86     ConnectorManager     23900  7008   0             05\17\2007-11:04:12:868    OnLocalDataAvailable called after service shutdown.
87     ConnectorManager     23900  7008   0             05\17\2007-11:04:12:868    GetHealthStatus called after service shutdown.


1. Manually uninstall the agent from the destination server.
2. Using regedit confirm that the following registry entry doesn’t exist:
HKLM\software\microsoft\microsoft operations manager\3.0\Agent Management Groups\%ManagementGroup%
3. Deploy the agent again either via the Management Server or Manually

May 14, 2007

Discoveries slow with a cluster?

Filed under: Issues, Microsoft, SCOM 2007 — opsmgr @ 8:35 pm

I have been working with SCOM for a while and I found that when you have a cluster that is being monitored the ScOM Root Management Server slows down with its discovery. I believe this is because when monitoring large clusters with many Databases and Virual Servers these are obviously viewed as Agentless devices. This is slightly contradictory as you actually do have an agent on each cluster node.

Its also becoming obvious to me that agent discovery is setup in a queue. This means that should you add a new system with lots of discoverable entities then this will need to complete first before the next lot of discoveries takes place.

When i mean discoveries I am talking about what the SCOM Agent will monitor, not server discoveries. My best advise to you if you find discovering slow, be patient 🙂

Recieve Error -2147217900 when installing SCOM RMS

Filed under: Errors, Microsoft, SCOM 2007 — opsmgr @ 5:02 pm

This error is an access error, its created when the SDK user account does not have write access to the SCOM database.

Windows Vista Client Monitoring MP for SCOM 07 Released

Filed under: Microsoft, News, SCOM 2007 — opsmgr @ 11:33 am

May 10, 2007

SRS Server Validation Error

Filed under: Errors, Microsoft, SCOM 2007 — opsmgr @ 10:12 pm

If you receive the error: SRS Server Validation Error while installing SCOM Reporting, dont forget you need to Configure Reporting Server first.

To do this you need to go START -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporing Services Configuration. Then on each of the Items that have a Red X or Yellow ! select them and configure them accordingly.

If you see any grey items this means that they cant be validated and even though you have configured another item it could be incorrect. The most common is the Initialisation option, if this is grey then you probably authentication.

SMS 2003 MP for SCOM 07 Released

Filed under: Microsoft, News, SCOM 2007 — opsmgr @ 9:48 pm

Enterprise Operations Management Architecture Design

Filed under: Architecture, Microsoft, SCOM 2007 — opsmgr @ 9:36 pm

Below is an example of a design I have build and implemented it shows the data flow and the distribution of data and load to increase redundancy and distribute network load.

SCOM Solution Design

« Newer PostsOlder Posts »

Create a free website or blog at