I was moving Operations Manager database today, but after everything went smooth, I get this error “SQL Server Broker for the Operations Manager database is disabled” How to fix it?
First of all stop all SCOM services in this order
- System Center Management Configuration
- Microsoft Monitoring Agent
- System Center Data Access Service
After that Open SQL Management Studio and do this SQL queries (run one by one)
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 everything is successful last query will give you result 1, so it means that SQL broker service is enabled.
Start Services in opposite order then stopping. Have a nice weekend