As the topic of the post suggests, there is a small bug in the SCCM SP1 slipstream setup. This should make into a KB sooner or later.
It occurs ONLY when upgrading from SMS 2003 SP2/SP3 to ConfigMgr 2007 SP1.
Note: Upgrading from SMS 2003 SP2/SP3 to ConfigMgr 2007 RTM is not affected by this issue.
Work around (2 options available):
1. Remove the Service from the command line:
sc delete SMS_SQL_MONITOR
2. OR remove these registry keys from the command line:
REG DELETE “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_SITE_COMPONENT_MANAGER\Component Servers\B21S1M13A\Components\SMS_SQL_MONITOR”
REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\SMS_SQL_MONITOR
PingBack from http://wbracken.wordpress.com/2008/09/27/sms_sql_monitor-service-fails-after-upgrade-to-sccm/