Installing MOM 2005 is a relatively start forward process and easily accomplished in most cases. If you are installing MOM reporting the install can become slightly more complicated in the time required to install the feature since you have to install Visual studio and SQL reporting in most cases.
However as a rule it is an easy install and the Prerequisite Checker includes checks that will promptly notify you of preinstall requirements that have been met and those that have not been met. As the install progresses as with most installs you can encounter issues or errors that roll back the installation process and this is where frustration takes its toll on most people. This was particularly true after the initial release of MOM 2005 since there was not an abundance of official Microsoft solutions available.
Since SQL server is required to host the MOM 2005 database it is important that the SQL installation is working as expected. Here we will discuss the two most frequent and easily corrected SQL issues.
You may receive the error that the SQL services are not correctly configured to start automatically. This is quite common if you are performing a clean install on new hardware or integrating MOM in your environment for the first time. It is simply a matter of setting the SQL Server (MSSQLSERVER) and the SQL Server Agent (SQLSERVERAGENT) services from manual to automatic in the services applet.
You may also encounter the error that the MOM database connectivity failed which is also a common issue when performing a clean install especially when the server is not connected to the Local Area Network (LAN) or the server is still in a workgroup and not joined to the domain where the setup application cannot connect to the SQL backend database.
Connect the server to the LAN if the Network Interface Card (NIC) is not connected. If the server is still in a workgroup add it to the domain or rerun the install and use domain credentials that have administrative permissions in the domain for the server hosting the SQL database.
No Comments