This article has been archived. It is offered "as is" and will no longer be updated.

Bug #: 470856 (SQL Server 8.0)

SYMPTOMS

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

CAUSE

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.

WORKAROUND

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:

Click Start, click Run, type Services.msc, and then click OK.

In the right pane of the Services window, locate MSSQL$SharePoint.

Right-click MSSQL$SharePoint, and then click Stop.

Close the Services window.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

When this problem occurs, the full dump file of the Service Control Manager may look similar to the following: