My MVP Profile

Monday, February 06, 2006

SQL SP4 Bug in MOM 2005 RTM

There is an often-encountered bug in the installation of MOM 2005 (RTM) on a SQL 2000 SP4 database. Workarounds are listed below:
 
MOM 2005 setup prior to SP1 looks for SQL SP3a and will choke on SP4. You
have a couple of options:

Download MOM 2005 SP1 (from MSDN subscriber downloads if you have access)
or use the following workaround for getting past the SQL 2000 SP4 issue is
to change a registry value for SQL back to the SP3 value, install MOM and
then restore the original value.

The registry key in question is the
HKEY_Local_Machine\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersio­­n.
Find the CSDVersion value and change it from " 8.00.2039" to "8.00.761".
Then install MOM 2005.  Then change the value back to "8.00.2039 ".  

Comments on "SQL SP4 Bug in MOM 2005 RTM"

 

davemack said ... (9:35 PM) : 

Thanks V had the exact problem when trying to re-install reporting services on MOM with SQL SP4. Thanks a million!

 

post a comment links to this post