SQL Server 2005 SP3 is now supported for SMS 2003 and ConfigMgr 2007

Just an FYI that I posted a note about SQL Server 2005 SP3 on our new ConfigurationMgr blog: http://blogs.technet.com/configurationmgr/archive/2009/01/06/sql-server-2005-sp3-is-now-supported-for-sms-2003-and-configmgr-2007.aspx Enjoy! J.C. Hornbeck | Manageability Knowledge Engineer


OpsMgr 2007: The DBCreatewizard utility fails with a BadImageformatException when run on a 64-bit OS

I’m going through a couple older issues and posting the resolutions just in case one of you happen to see the same thing.  The first regards running DBCreateWizard on a 64-bit OS: ======== Issue: The DBCreatewizard utility fails with BadImageformatException when run on a 64-bit OS: System.BadImageFormatException: Could not load file or assembly ‘Microsoft.Mom.UI.Wrappers, Version=6.0.4900.0,…


OpsMgr 2007: How to search the entire database for a string value or GUID

Here is an older tip but it’s one we use (or some variation) quite a bit in support.  This originally came from Narayana Vyas Kondreddi at http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm so we can’t take all the credit.  If you need to find a value in a table but you’re not sure where to look, this can be a…


ConfigMgr 2007: Moving the Site Database

I saw an article describing how to move the DB for Ops Manager 2007 but I didn’t see one for Configuration Manager so I decided to write one up.  Really the process is about the same but I wanted to have something product specific. ======== INTRODUCTION This article describes how to move the Site Database…


OpsMgr 2007: Troubleshooting Console Performance in large environments

I’ve been getting a few questions lately about slow performance with the console so I thought a post might be in order.  Luckily for me, Tim Helton, one of our top Support Escalation Engineers, had already written some great tips that he uses to troubleshoot these kinds of issues.  His notes are below: ======== These…


OpsMgr 2007: Reports are blank - Event ID: 31565 generated on the RMS

We’re starting to see more of these issues come in so I wanted to make sure you all were aware of it.  Thanks to Support Engineer Milan Jajal for uncovering this: ======== Issue: After the installation of System Center Operations Manager 2007 Reporting, no reports are listed under Reporting pane in the Operations Console. In…


OpsMgr 2007: Supported Clustering Configurations

I’ve been hearing a lot of questions lately about what the supported clustering configurations for OpsMgr 2007 are so I wanted to post this quick graphic that may help explain things a little bit.  One of our top Program Managers for System Center Operations Manager 2007, Satya Vel, put this together but I’m sure he…


SCOM2007: Moving the Operations Manager Database

There may be certain situations where you need to move the Operations Manager database (OperationsManager) from one SQL Server 2005-based computer to another, including the following: · The current server is experiencing hardware issues and is not considered reliable. · The OperationsManager database is collocated on the same server as the Root Management Server and…