Alberto Ortega’s Blog

After you installed your MOM Reporting server, the next thing you should do is to import all reports included in the MOM Management Packs.

During the MOM Reporting setup the Reporting User Account must be specified. If this account is not part of the BUILTIN\Administrators group on the Reportig Server, any attempt to render the reports will have the same error as output:

…( rsProcessingAborted )…
Logon failure: the user has not been granted the requested logon type at this computer.

This is because Default security settings on SQL Reporting Services list only the BUILTINT\Administrators group as the allowed users to execute reports. You have tow possible solutions:

1. Make the Reporting User Account member of a group that is member of the BUILTIN\Adminsitrators group on the MOM Reporting Server. (Not so desirable for the security environment)
2. Add a security group that the Reporting User Accounts belongs to, to the SQL Server Services security settings. (Recommended)

Solving this permissions issue you will be able to see any Management Pack report. Enjoy!

After you installed MOM Reporting Server the SQLAgent service began reporting the same recurrent error:

Event ID: 318
Unable to read local eventlog (reason: The data area passed to a system call is too small).

If you pay attention this error occurs everytime the MOM Reporting DTS package runs. Don´t worry about it, this is a known bug in DTS in SQL Server that occurs when a DTS package
logs to the event log and has more then 50 steps (KB: http://support.microsoft.com/?id=811484 ). The MOM Reporting DTS package fits this description. You can ignore the error as nothing has failed or gone wrong.

You might check the event log to make sure your DTS package is succeeding.

There is an issue when trying to install a MOM 2005 Database Server on a SQL Server 2000 wich has SP4 installed on it.

The required version is SQLServer 2000 + SP3a, installation should be possible since SP4 is a newer SP than SP3, to troubleshoot this, do the following:

Alter the CSDVersion entry located at:
HKEY_Local_Machine\SOFTWARE\Microsoft\Microsoft SQL Server\SQL2000\MSSQLServer\CurrentVersion

If SP4 is installed, the version number will be 8.00.2039. To get the MOM 2005 Database to install, you need to change the version number to 8.00.761 which is the same one for SP3A and then change it back again after the installation is completed.

This Issue will be solved by MOM 2005 SP1, for the meanwhile this workaround should work for you.

Besides that, the SQL Server and SQL Server Agent services must be in automatic startup mode, for clusters they can be manual startup.

After this configuration is performed you will be pass the pre-requisites step and you can install the MOM 2005 Databa Server.