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

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:

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


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:


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 (6)

  1. gmaloy says:

    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.



  2. Anonymous says:

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

  3. Anonymous says:

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

  4. Anonymous says:

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

  5. Anonymous says:

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

  6. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    Sign Up & Do registration for latest movies on Showbox application

Skip to main content