SCOM discovery fails

Hi,

In case you are unable to discover devices on your network and see error related to SQL broker service not running then run below sql query against OperationsManager DB to check the status and enable it:

SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'   if status 0, means disable and need to be enabled using following queries

ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE OperationsManager SET ENABLE_BROKER

ALTER DATABASE OperationsManager SET MULTI_USER

SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'  if status 1, then you are good to run discovery now.


Thanks,
Varun