A colleague and I were troubleshooting an issue on a customer site where the discovery of available Windows Computers to have an agent deployed to them would never end. While we got around the issue by installing the agents manually on the servers to be monitored this is hardly practical for large data centers.
We came to a stand still and needed a solution when faced with getting the Cross platform extensions for Operations Manager to work. For those unfamiliar with Cross Platform extensions, Microsoft is making these available to monitor Unix based computers with an agent in the same manner as Windows based computers in operations Manager 2007.
Currently, you can install Cross platform extension agents manually on Unix servers however there is a portion of the installation which still relies on the discovery wizard to validate the installation before the system information will be inserted in the OpsMgr database and data warehouse so that it can be monitored.
We found the solution after an exhaustive search of Microsoft sources and although this can be accomplished using SQL Server Management studio, my colleague John Hann wrote a TSQL script to enable the broker on the OpsMgr database.
Here is the script:
USE master;
GO
CREATE ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP ( LISTENER_PORT = 4037 )
FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;
GO
ALTER DATABASE
OperationsManager SET ENABLE_BROKER
Enjoy all!