From: David Hay on
After a failed update to SQL 2008 SP1 + CU8, I restored master, and
then tried to do a repair on the install to make sure I was back to
SP1 only. I now get the following error:


SQL Server 2008 - Developer Edition x64
Windows Server 2008 R2 x64
There was an error executing the Replication upgrade scripts

TITLE: Microsoft SQL Server 2008 Setup
------------------------------

The following error has occurred:



There was an error executing the Replication upgrade scripts. See the
SQL Server error log for details.

For help, click:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2775.0&EvtType=0x21F8068D%25400xC652C608%25401311%254038014



Running Action: ReplConfigAction_repair_Startup_Cpu64
Action Data:
Feature = SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu64
Scenario = repair
Timing = Startup
ConfigObjectType =
Microsoft.SqlServer.Configuration.Repl.ReplConfigurationPrivate
FeatureName = SQL_Replication_Core_Inst
FeatureCpuType = Cpu64
FeaturePackageId = sql_engine_core_inst
FromVersion =
InstallId = Machine[@ID='Servername']/Product[@ID='SQL2008']/
Instance[@ID='MSSQLSERVER']/Feature[@ID='SQLEngine_CTP5' and
@RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server
\MSSQL10.MSSQLSERVER\Setup' and @RootPath='SOFTWARE\Microsoft
\Microsoft SQL Server\MSSQL10.MSSQLSERVER']/
Install[@ProductCode='FBD367D1-642F-47CF-B79B-9BE48FB34007']
Repair: Repl Configuration
--ReplConfigurationPrivate: Checking Replication upgrade script
status.
Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE,
machine
Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft
SQL Server\MSSQL10.MSSQLSERVER\Replication\Setup
Sco: Attempting to get registry value Upgraded
Sco: Attempting to get registry value kind for value Upgraded
Configuration action failed for feature SQL_Replication_Core_Inst
during timing Startup and scenario Startup.
There was an error executing the Replication upgrade scripts. See the
SQL Server error log for details.
Configuration action failed for feature SQL_Replication_Core_Inst
during timing Startup and scenario Startup.
Microsoft.SqlServer.Configuration.Repl.ReplConfigException: There was
an error executing the Replication upgrade scripts. See the SQL Server
error log for details.
at
Microsoft.SqlServer.Configuration.Repl.ReplConfigurationPrivate.CheckUpgradeScriptStatus()
at
Microsoft.SqlServer.Configuration.Repl.ReplConfigurationPrivate.RepairImpl(ConfigActionTiming
timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
at
Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario
scenario, ConfigActionTiming timing, Dictionary`2 actionData,
PublicConfigurationBase spcbCurrent)
at
Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario
scenario, ConfigActionTiming timing, Dictionary`2 actionData,
PublicConfigurationBase spcbCurrent)
at
Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String
actionId)
at
Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String
actionId, TextWriter errorStream)
Exception: Microsoft.SqlServer.Configuration.Repl.ReplConfigException.
Source: Microsoft.SqlServer.Configuration.Repl_ConfigExtension.
Message: There was an error executing the Replication upgrade scripts.
See the SQL Server error log for details..
Watson Bucket 1