SCOM Discovery Wizard Does Not Work.

Если после миграции с SCOM2007 на SCOM2012 вы с удивлением обнаруживаете, что любое обнаружение устройств неизбежно заканчивается зависанием мастера, то:

1. - Open SQL Server Management Studio

- Select the right instance and the OpsMgr database

- Start a new query on the OpsMgr database:

SELECT is_broker_enabled FROM sys.databases WHERE name = 'OperationsManager'

- Value = 0 :SQL Broker is disabled. Goto Step 2.

- Value= 1 : SQL Broker is enabled. All is OK.

2. - 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 SINGLE_USER WITH ROLLBACK IMMEDIATE

- Click Execute

- Start this query on the OpsMgr database:

ALTER DATABASE OperationsManager SET ENABLE_BROKER

- Click Execute

- Close SQL Server Management Studio.

Note: Closing SQL Server Management Studio closes the connection to the database in single user mode. Most of the times one has to 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.

3. - 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.