First published on TECHNET on Apr 25, 2006
MOM 2005 Service Pack 1 operational database and Reporting data warehouse now support SQL Server 2005 and above(Service Packs). To add support for SQL Server 2005 to the MOM operational database and the MOM Reporting data warehouse, you need to download and install the following three MOM 2005 hotfixes which can be found at the KB article link below.
KB article announcing MOM 2005 SP1 support for SQL 2005 is now live at
http://support.microsoft.com/?kbid=917615
.
Note: Reporting may sometimes give an error message such as "The version of the report server database is either in a format that is not valid, or it cannot be read." The found version is 'C.0.6.54'. The expected version is 'C.0.8.40'.To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase).
This isssue is fixed in SQL 2005 Service Pack 1 which is avaliable at:
http://www.microsoft.com/sql/sp1.mspx
Satya
