Error message when you install an instance of SQL Server 2008 after you uninstall a previous instance of SQL Server 2008: "The specified service has been marked for deletion"


Symptoms


Consider the following scenario. You enable the FILESTREAM feature for an instance of Microsoft SQL Server 2008. Then, you uninstall the instance. On the same computer, you try to install a new instance of SQL Server 2008. When you try to install the new instance, you select the configuration of the FILESTREAM feature to be performed during the setup process. In this scenario, you receive the following error message:
The following error has occurred:


The specified service has been marked for deletion. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.


For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1442.32&EvtType=Microsoft.SqlServer.Configuration.Sco.Service.ChangeServiceConfig%2540System.ComponentModel.Win32Exception

Additionally, you notice the following error message in the Detail.txt log file:
Date Time SQLEngine: : Checking Engine checkpoint 'StartRsFxService'

Date Time Slp: Sco: Attempting to set service start mode for service RsFx0102, start mode System

Date Time Slp: Sco: Attempting to open SC Manager

Date Time Slp: Sco: Attempting to open service handle for service RsFx0102

Date Time Slp: Invoking ChangeServiceConfig Win32 API

Date Time Slp: Sco: Attempting to close service handle for service RsFx0102

Date Time Slp: Sco: Attempting to close SC Manager

Date Time Slp: Prompting user if they want to retry this action

Date Time Slp: User has chosen to cancel this action

...
Date Time Slp: The specified service has been marked for deletion.


Date Time Slp: Watson bucket for exception based failure has been created

Date Time Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.

Note The Detail.txt file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Log

Cause


This issue occurs because some components that belong to the FILESTREAM feature are not completely uninstalled when you uninstall SQL Server 2008. A known issue in Windows Vista Service Pack 1 and in Windows Server 2008 causes the shared folder for the FILESTREAM feature not to be deleted successfully. (This problem is described in article 949857 in the Microsoft Knowledge Base.) Therefore, when you try to install a new instance of SQL Server 2008 immediately following an uninstall operation, this issue occurs.

Resolution


To resolve this issue, apply the hotfix that is described in the following article in the Microsoft Knowledge Base:
949857 Error message when you try to delete a folder after an SMB share has been removed on a computer that is running Windows Vista Service Pack 1 or Windows Server 2008: "The action can't be completed because the folder is open in another program"

Workaround


To work around this issue, restart the computer, and then rerun the Setup program to install the new instance of SQL Server 2008.

Status


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

More Information


You can examine the status of the FILESTREAM driver by running the following command:
sc query rsfx0102
When you run this command before you uninstall the instance of SQL Server 2008, you receive the following result:

SERVICE_NAME: rsfx0102

TYPE : 2 FILE_SYSTEM_DRIVER

STATE : 4 RUNNING

(STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)

WIN32_EXIT_CODE : 0 (0x0)

SERVICE_EXIT_CODE : 0 (0x0)

CHECKPOINT : 0x0

WAIT_HINT : 0x0


When you run the command after you uninstall the instance of SQL Server 2008, you receive the following result:

SERVICE_NAME: rsfx0102

TYPE : 2 FILE_SYSTEM_DRIVER

STATE : 4 RUNNING

(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)

WIN32_EXIT_CODE : 0 (0x0)

SERVICE_EXIT_CODE : 0 (0x0)

CHECKPOINT : 0x0

WAIT_HINT : 0x0