Is SQL Broker required for SCSM?


Long story short, the answer is YES. You can check the current status of SQL Broker with this:

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

The result should be 1. If you get a value of zero, then it is strongly recommended that you enable this feature by running the statements below.

Please ensure NOT to run these statements in working hours, since all connections to the ServiceManager database will be closed.

For more detailed info why SCSM is using SQL Broker check this: http://social.technet.microsoft.com/Forums/systemcenter/en-US/f16680c3-e906-4704-8d67-22c71c53472b/service-manager-db-sql-server-broker?forum=systemcenterservicemanager 

 

USE master

GO

ALTER DATABASE ServiceManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE ServiceManager SET ENABLE_BROKER

ALTER DATABASE ServiceManager SET MULTI_USER

 

Thanks

Kubilay Hüsmenoğlu

Comments (0)

Skip to main content