SCOM Discovery Wizard stuck and doesn’t show any discovery

SCOM Discovery Wizard stuck and doesn’t show any discovery

The SCOM Discovery Wizard can run forever without ever discovering a single system eventhough the systems to be discovered are up & running and not restricted by a firewall.

That is because The SQL Broker of the OperationsManager database is not running or the SCOM Database Owner is incorrect. Without it, the Discovery Wizard will not function.

Solution -:

  1. Check to see whether the SQL Broker is running
    – Open SQL Server Management Studio -> connect to right instance and select the OperationsManager database
    – right click on OperationsManager -> new query -> type below query
    SELECT is_broker_enabled FROM sys.databases WHERE name = ‘OperationsManager’
    – Value = :SQL Broker is disabled. Goto Step 2.
    – Value= 1 : SQL Broker is enabled. All is OK and you might want to check DB owner mentioned in step 3
  1. Enabling the SQL Broker for the OperationsManager database
    – Open SQL Server Management Studio -> connect right instance and select OperationsManagerdatabase
    – right click on OperationsManager database -> new query  -> execute below query
    ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    – Click Execute

–Note : stop all SCOM related services on the RMS since these services have running connections to this database. Without stopping them one won’t be able to run the next query.
ALTER DATABASE OperationsManager SET ENABLE_BROKER
– Click Execute
– Open SQL Server Management Studio

– Select the right instance and the OpsMgr database

– Start a new query on the OpsMgr database:
ALTER DATABASE OperationsManager SET MULTI_USER
– Click Execute.

Repeat Step 1 to check the SQL Broker is running now (value must be 1)

  1. Change Database Owner to SA

– Start SQL Server Management Studio
–  Go to Databases –> System Databases
–  Select Properties
– On the Select a Page select Files
–  On the right under header Database the current owner is displayed
–  Check the account. It’s not the dedicated AD account? Click the button with the 3 dots
– The screen ‘Select Database Owner’ appears
–  Click Browse. Select the dedicated AD account
–  Save the modifications
–  Close all screens

 

(Visited 505 times, 1 visits today)

Add a Comment

Facebook