By default, CCS configures the SQL Server Service Broker. If you have configured the SQL Server Service Broker for any specific scenario, then you must execute the stored procedure, spManageUDMSQLBroker.
The scenarios for which the configuration of the SQL Server Service Broker can change are as follows:
The reporting database is installed or upgraded by a user who is not in the role of a dbo.
The reporting database is recovered from the back-up.
The user credentials that are configured to access or synchronize the reporting database have changed.
You must execute the stored procedure, spManageUDMSQLBroker to activate and configure the SQL Server Service Broker for the specific user context. You must execute the stored procedure in the user context that has the privileges to run the database synchronization process.
To enable SQL broker
In the SQL Server Management Studio, expand Databases.
Right-click CSM_Reports, and click New Query.
Run the following command:
exec dbo.spManageUDMSQLBroker 1, <Reporting user name>,CSM_Reports