Installing the MOM Database when Deploying MOM 2005 across Multiple Computers

To install the MOM database, you must first install and correctly configure SQL Server 2000 Service Pack 3a or later for use by the MOM database. You should also install all recommended hotfixes for SQL Server 2000 SP3a. If you are installing the MOM database on an existing SQL Server, you must verify that it is correctly configured.

A known issue might arise when MOM is bulk inserting data into the MOM database. A server process ID (SPID) might stop responding with a NETWORKIO (0x800) waittype and a constantly increasing waittime in SQL Server 2000 Enterprise Manager under Process Info or in the sysprocesses table in the master database. The only way to end the process is to remove the SPID.

You can obtain and install this hotfix:

https://support.microsoft.com/default.aspx?scid=kb;en-us;884554

Important

Installing the MOM 2005 Database on the Microsoft SQL Server Desktop Engine (MSDE) is not supported.

For more information about SQL Server configurations that have both SQL Server 2000 and SQL Server 7.0 installed, see article number Q300341 in the Microsoft Knowledge Base at https://go.microsoft.com/fwlink/?LinkId=33376. It is recommended that you review all articles related to SQL Server and MOM at https://go.microsoft.com/fwlink/?linkid=10716.

Note

If you are installing the MOM database on a cluster SQL Server, follow the steps in Chapter 7, "Deploying MOM in Advanced Environments" to install the database, and then return to this chapter to finish your installation.