Forum Discussion
Julian_Balog_34
Oct 21, 2009Historic F5 Account
Problem with malformed device (big3d) version
(originally posted by: Roquencourt, Jean-Baptiste
I have done the installation with the default installation path (using v.1.4.93).
I’ve manually upgraded the big3d version.
I ...
Julian_Balog_34
Oct 23, 2009Historic F5 Account
Hey Jean-Baptiste,
My first guess is that you may not have the SQL Service Broker enabled for the OperationsManager SQL database. Folow these steps please to enable it. Make sure you have sufficient SQL privileges on the OperationsManager database to perform these actions (~db_admin).
1.Stop the SCOM SDK service.
2.Open SQL Server Management Studio and connect with SQL admin privileges to the SQL Server hosting the OperationsManager database.
3.Click New Query.
4.In the query window, enter the following query: ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5.Click Execute and make sure the command completed successfully: you should get something similar to: “Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.”
6.Clear the content of the current query window and enter the following query: ALTER DATABASE OperationsManager SET ENABLE_BROKER
7.Click Execute and make sure the command completed successfully.
8.Clear the content of the current query window and enter the following query: ALTER DATABASE OperationsManager SET MULTI_USER
9.Click Execute and make sure the command completed successfully.
10.Clear the content of the current query window. You can verify the setting for ENABLE_BROKER is set to 1 by using this SQL query: SELECT is_broker_enabled FROM sys.databases WHERE name='OperationsManager'. You would get something similar to: is_broker_enabled | 1.
11.Restart the SCOM SDK service.
Let me know how it goes.
Thanks,
Julian
Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects
