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

Vrijedi za: SQL Server 2008 StandardSQL Server 2008 Standard Edition for Small BusinessSQL Server 2008 Enterprise

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

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.

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:

Status


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