MOM 2005 Management Server Connection to OnePoint
I recently ran into this problem, where a management server would get rebooted, the mom service would start however no events or alerts would be passed from the Management Server to the onepoint db. Restarting the service would not help the connection get reestablished.
I tried the following test from the remote management server, I created a test ODBC connection using the SQL Server instance name but not specify the SQL port just left it at dynamically determine and the connection to the database failed. So I created a second ODBC connection this time specifying the port number to be used, and this time the connection was good.
I check the registry on that management server to see how it was connecting and sure enough the port number was not specified, I change the following registry key and restarted the MOM Service and the management server was back in business.
HKLM\SOFTWARE\Mission Critical Software\DASServer\DataSource
SQLServerName\InstanceName,YourSQLPortNumber
There is a second place where the SQL Database connection is mentioned in the registry for MOM 2005 and I wanted to bring it up.
HKLM\SOFTWARE\Mission Critical Softare\Configurations\*YourMgtGroupName*\Operations\Database
I made the changes in both places just in case that registry key is ever referenced.