The System Center Operations Manager Support Team Blog

This is the OpsMgr 2007 blog for the Microsoft support team. If you were looking for the SCOM 2007 or MOM 2005 blog then you are in the right place.

OpsMgr 2007: Discovery Wizard never ends and no computers are discovered

OpsMgr 2007: Discovery Wizard never ends and no computers are discovered

  • Comments 5
  • Likes

This is kind of a weird one but I came across it the other day and thought it might be worth a quick heads-up.  Normally you wouldn't think this would be a common issue, and in reality it isn't, but with the economy the way it is right now this may be something you eventually run into:

========

Issue: You use the Discovery Wizard from the OpsMgr 2007 console on an RMS server and it is unable to discover any computers and never actually finishes.

Cause: This can occur if the owner of the OperationsManager database is deleted.  For example, this can happen if the user who installed OpsMgr is no longer with the company and his or her user account is deleted from the domain.

Resolution: Check the owner of the OperationsManager database by opening the SQL Management studio and going to the
OperationsManager Database properties.  It may not be able to open the database properties and give the error below:

Property Owner is not available for Database '[OperationsManager]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&Ev
tSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrieved
ExceptionText&EvtID=Owner&LinkId=20476

You can check who the owner of the database is by running this query:

sp_helpdb

If you're experiencing this issue then this command will show that OperationsManager DB has a NULL value for the owner column.

You can do a reset of the DB owner to 'sa' with following script:

sp_changedbowner 'sa'

Note: This is just an example and the actual DB owner may vary depending on your specific configuration. 

Then run the query below again to verify the DB owner:

sp_helpdb

Now it should show 'sa' as owner for the Operations Manager database.  Try accessing properties of Operations Manager database again and it should now show the properties successfully.  Assuming it does, restart the SDK service, the Config service and the Health services on the RMS server.  Once you do this discovery should complete successfully.

========

Hopefully this isn't a situation you run into but just in case now you'll have an idea on what causes it and how to fix it.  And a special thanks to Milan Jajal for doing the initial work and writing this up.  Thanks Milan!

J.C. Hornbeck | Manageability Knowledge Engineer

Comments
  • Just an FYI that I posted about an issue where a missing db owner can cause discovery to fail over on

  • OpsMgr 2007: Discovery Wizard never ends and no computers are discovered Feed: The Operations Manager

  • This is kind of a weird one but I came across it the other day and thought it might be worth a quick

  • I had this same behavior in SCOM and found out when I tried to do a Change Priamry Server for an agent, I got a SQL exception error telling me the the primnary file group was full on the SQL DB "Operations Manager". The discovery just sat there in discovery mode ticking away for hours and never stopped.

    After the DBA created more space for the DB the discovery ran fine.

    George

    Motricity

  • Very helpful. We ran into this after UPNs got changed as part of a new naming convention.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment