Monday, February 20, 2012

MOM Reporting Configuration Query?

My current environment is as follows:
MOM 2005 SP1 Frontend & DAS
MOM 2005 SP1 Frontend
MOM 2005 SP1 DB w/ SQL 2000 SP4
SQL Reporting Services 2000 w/ MOM 2005 SP1 Reporting Pack
Will applying SQL 2000 RS SP2 break MOM reporting?No it won't. Whilst the RTM MOM Reporting install complains if RS SP2 is
installed when you try and initially install MOM Reporting, if you apply SP2
after you have installed MOM Reporting it should be fine. I just tried this
and then added some new reports from a management pack and it worked fine.
The link below also has this quote that seems to confirm this
"With MOM 2005 Service Pack 1, you can use SQL 2000 Reporting Services SP2,
which is independent of service packs for SQL Server 2000."
http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/1e823712-c25b-4107-941d-e078f3937f3e.mspx
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<damian.yates@.gtsi.com> wrote in message
news:1140192996.396977.158350@.g14g2000cwa.googlegroups.com...
> My current environment is as follows:
> MOM 2005 SP1 Frontend & DAS
> MOM 2005 SP1 Frontend
> MOM 2005 SP1 DB w/ SQL 2000 SP4
> SQL Reporting Services 2000 w/ MOM 2005 SP1 Reporting Pack
>
> Will applying SQL 2000 RS SP2 break MOM reporting?
>

No comments:

Post a Comment