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.

The installation fails when you try to install a new instance of SQL Server 2008 on an x64-based computer


View products that this article applies to.

Symptoms

When an instance of the x86-based version of Microsoft SQL Server 2008 and an instance of the x64-based version of SQL Server 2008 are installed on an x64-based computer, and you try to install a new instance of one version after you uninstall the instance of the other version, the installation fails. For example, the installation fails if you try to install a new instance of the x64-based version after you uninstall the x86-based version.

When this problem occurs, the following errors appear in the SQL Server 2008 log:
Date Time Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.

Date Time Slp: System.ArgumentException: Cannot find service {0}.

Date Time Slp: Nazwa parametru: MSSQLServerADHelper100

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.ChangeServiceSecurity(EffectiveProperties properties)

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install_ConfigNonRC_Prepare(EffectiveProperties properties)

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)

Date Time Slp: w Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)

Date Time Slp: Exception: System.ArgumentException.

Date Time Slp: Source: Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.

Date Time Slp: Message: Cannot find service {0}.

Date Time Slp: Nazwa parametru: MSSQLServerADHelper100.
Date

↑ Back to the top


Cause

This problem occurs because the SQL Server Active Directory Helper Service is removed when you uninstall any instance of SQL Server 2008. On an x64-based computer, both 32-bit instances and 64-bit instances share the SQL Server Active Directory Helper service. However, a separate reference count of the service is maintained for each platform. Therefore, when you uninstall the last instance of either platform, the SQL Server Active Directory Helper service is deleted.

If multiple instances of a single platform are installed, this problem does not occur.

↑ Back to the top


Workaround

To work around this problem, repair the installation of the remaining instance of SQL Server 2008. When you repair the installation, the SQL Server Active Directory Helper Service is restored.

For more information about how to repair an installation of SQL Server 2008, visit the following Microsoft Developer Network (MSDN) Web site:

↑ 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


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

↑ Back to the top

Article Info
Article ID : 955493
Revision : 3
Created on : 4/18/2018
Published on : 4/19/2018
Exists online : False
Views : 613