BUG: SQL Server Setup stops responding when you upgrade an instance of SQL Server Desktop Engine (Windows) to SQL Server 2000

This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 470856 (SQL Server 8.0)
You upgrade a default instance of Microsoft SQL Server 2000 to SQL Server 2000 Service Pack 3 (SP3) on a computer that is running Microsoft Windows Small Business Server 2003. If you try to upgrade the instance of Microsoft SQL Server 2000 Desktop Engine (Windows) that corresponds to Microsoft Windows SharePoint Services to SQL Server 2000, SQL Server Setup stops responding. You receive the following error message:
Setup is preparing to copy files
The Service Control Manager (Scm.exe) experiences a time-out when it tries to stop the MSSQL$SharePoint service.

Note The MSSQL$SharePoint service is the Microsoft Windows service for the instance of SQL Server 2000 Desktop Engine (Windows) that corresponds to Windows SharePoint Services.
To work around this problem, you must manually stop the MSSQL$SharePoint service before you start the Setup program to upgrade the instance of SQL Server 2000 Desktop Engine (Windows).

Note If the Setup program stops responding with the message that is mentioned in the "Symptoms" section, you can manually stop the MSSQL$SharePoint service to continue the upgrade process.

To manually stop the MSSQL$SharePoint service, follow these steps:
  1. Click Start, click Run, type Services.msc, and then click OK.
  2. In the right pane of the Services window, locate MSSQL$SharePoint.
  3. Right-click MSSQL$SharePoint, and then click Stop.
  4. Close the Services window.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
When this problem occurs, the full dump file of the Service Control Manager may look similar to the following:
# ChildEBP RetAddr 00 0012f184 77f4262b SharedUserData!SystemCallStub+0x401 0012f188 77e418ea ntdll!NtDelayExecution+0xc [d:\srv03rtm\base\ntdll\daytona\obj\i386\usrstubs.asm @ 611]02 0012f1f0 77e416ee kernel32!SleepEx(unsigned long dwMilliseconds = 0x1388, int bAlertable = 0)+0x68 [d:\srv03rtm\base\win32\client\synch.c @ 1646]03 0012f1fc 00405bec kernel32!Sleep(unsigned long dwMilliseconds = <Memory access error>)+0xb [d:\srv03rtm\base\win32\client\synch.c @ 1570]04 0012f218 0040181c scm!CServiceNT::Stop(int bStopDependents = <Memory access error>)+0x11c [..\shared\csvcnt.cpp @ 327]05 0012ff14 00401321 scm!CApp::RunThread(void * lpv = 0x00000000)+0x41c [app.cpp @ 445]06 0012ff34 00408a03 scm!CApp::Run(int nCmdShow = <Memory access error>)+0x11 [app.cpp @ 246]07 0012ffc0 77e4f38c scm!WinMainCRTStartup(void)+0xce [crt0.c @ 198]08 0012fff0 00000000 kernel32!BaseProcessStart(<function> * lpStartAddress = 0x00408935)+0x23 [d:\srv03rtm\base\win32\client\support.c @ 580]
Hangs hung upgradation WMSDE

Article ID: 841773 - Last Review: 01/17/2015 17:54:14 - Revision: 1.3

Microsoft SQL Server 2000 Desktop Engine (Windows)

  • kbnosurvey kbarchive kbtshoot kbservice kbscm kbpreinstall kbupgrade kbsetup kbbug KB841773