SCCM SP1 slipstream setup on SMS 2003 SP2/SP3 site fails to remove SMS_SQL_MONITOR service


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