Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

↑ Back to the top


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.

↑ Back to the top


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"

↑ Back to the top


Workaround

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

↑ Back to the top


Status

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

↑ Back to the top


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

↑ Back to the top


Keywords: sql2008relnoteinstallation, sql2008relnoteconfiguration, sql2008relnote, kbtshoot, kbexpertiseadvanced, kbprb, kb, misc_migrate_32718

↑ Back to the top

Article Info
Article ID : 955668
Revision : 3
Created on : 4/13/2018
Published on : 4/13/2018
Exists online : False
Views : 731