"Failed to Connect to the Database" Error Message When You Connect to the Microsoft Operations Manager Database Through a Firewall

When you use the MOM Administrator console to remotely connect to a Microsoft Operations Manager (MOM) database, you may receive the following error message:

This issue may occur if you try to connect to the MOM database through a firewall from a remote computer, and the port for the connection to the MOM database is blocked. By default, the computer that runs Microsoft SQL Server 2000 and contains the MOM database uses port 1433 to receive data from the Database-Consolidator-Agent Manager (DCAM) server and for MOM Microsoft Management Console (MMC) connections. You cannot make these connections if this port is blocked.

To resolve this issue, open port 1433 on the firewall or reconfigure SQL server to communicate over a port that is available on the firewall. To reconfigure SQL communications, follow these steps:

1. On the SQL server that contains the MOM database, modify the port that the SQL server uses.
   
   For additional information about how to modify ports in SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
   294453  (http://support.microsoft.com/kb/294453/ ) INF: How to Set Up SQL Server 2000 to Listen on Multiple Static TCP Ports
2. On the DCAM server, you must install the SQL Client Utilities, and then use the SQL Client Network Utility to configure the port to send data to the SQL server.
   
   For additional information about static and dynamic port allocation in SQL server 2000, click the following article number to view the article in the Microsoft Knowledge Base:
   823938  (http://support.microsoft.com/kb/823938/ ) HOW TO: Understanding the Static and Dynamic Ports Allocation In SQL