none
SQL server 2008 Upgrade Issue

    Question

  • We are facing problem in upgrading our SQL server 2005 SE to SQL Server 2008 EE.

    Popup Msg :-
    TITLE: Microsoft SQL Server 2008 Setup
    ------------------------------
    The following error has occurred:
    Not all privileges referenced are assigned to the caller.
    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.1600.22&EvtType=0xFF16C34E%25400x5D9A8C61

    Error log from Setup bootstrap details.txt file.


    2009-10-19 10:11:11 Slp: ----------------------------------------
    2009-10-19 10:11:12 Slp: User has chosen to retry this action
    2009-10-19 10:11:12 Slp: Prompting user if they want to retry this action due to the following failure:
    2009-10-19 10:11:12 Slp: ----------------------------------------
    2009-10-19 10:11:12 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2009-10-19 10:11:12 Slp: Inner exceptions are being indented
    2009-10-19 10:11:12 Slp:
    2009-10-19 10:11:12 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    2009-10-19 10:11:12 Slp:     Message:
    2009-10-19 10:11:12 Slp:         Not all privileges referenced are assigned to the caller.
    2009-10-19 10:11:12 Slp:        
    2009-10-19 10:11:12 Slp:     Data:
    2009-10-19 10:11:12 Slp:       WatsonData = SOFTWARE\Microsoft\Microsoft SQL Server
    2009-10-19 10:11:12 Slp:       DisableRetry = true
    2009-10-19 10:11:12 Slp:     Inner exception type: System.ComponentModel.Win32Exception
    2009-10-19 10:11:12 Slp:         Message:
    2009-10-19 10:11:12 Slp:                 Not all privileges referenced are assigned to the caller.
    2009-10-19 10:11:12 Slp:                
    2009-10-19 10:11:12 Slp:         Stack:
    2009-10-19 10:11:12 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    2009-10-19 10:11:12 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    2009-10-19 10:11:12 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.WriteHklmRegistryKeyToFile(ServiceContainer ctx, String keyName, String fileName)
    2009-10-19 10:11:12 Slp: ----------------------------------------
    2009-10-19 10:11:13 Slp: User has chosen to retry this action
    2009-10-19 10:11:13 Slp: Prompting user if they want to retry this action due to the following failure:
    2009-10-19 10:11:13 Slp: ----------------------------------------
    2009-10-19 10:11:13 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2009-10-19 10:11:13 Slp: Inner exceptions are being indented
    2009-10-19 10:11:13 Slp:
    2009-10-19 10:11:13 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    2009-10-19 10:11:13 Slp:     Message:
    2009-10-19 10:11:13 Slp:         Not all privileges referenced are assigned to the caller.
    2009-10-19 10:11:13 Slp:        
    2009-10-19 10:11:13 Slp:     Data:
    2009-10-19 10:11:13 Slp:       WatsonData = SOFTWARE\Microsoft\Microsoft SQL Server
    2009-10-19 10:11:13 Slp:       DisableRetry = true
    2009-10-19 10:11:13 Slp:     Inner exception type: System.ComponentModel.Win32Exception
    2009-10-19 10:11:13 Slp:         Message:
    2009-10-19 10:11:13 Slp:                 Not all privileges referenced are assigned to the caller.
    2009-10-19 10:11:13 Slp:                
    2009-10-19 10:11:13 Slp:         Stack:
    2009-10-19 10:11:13 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege.SetPrivilege(Boolean enable)
    2009-10-19 10:11:13 Slp:                 at Microsoft.SqlServer.Configuration.Sco.AdjustTokenPrivilege..ctor(String privilege)
    2009-10-19 10:11:13 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.WriteHklmRegistryKeyToFile(ServiceContainer ctx, String keyName, String fileName)
    2009-10-19 10:11:13 Slp: ----------------------------------------

    guessing privileges issue but installation login and sqlserver login both are available system admin.
    Can any one suggest or guide me to solve this issue.

    Thanks

    Monday, October 19, 2009 2:50 PM

Answers

  • Bacause of the time constraint, I have installed the new named instance and moved the settings to new instance.
    Thanks a lot and i appreciate who ever responded.

    Thursday, October 22, 2009 4:44 PM

All replies

  • Hello,

    Please see the following link, which explains the cause and the user action needed to solve the issue:

    http://msdn.microsoft.com/en-us/library/ms838282.aspx


    Regards,

    Alberto Morillo
    SQLCoffee.com

     

     

    Monday, October 19, 2009 3:09 PM
    Moderator
  • we fixed the login issue  but when we do the repair again it showed with new error.
    The specified user 'XXXXX@XXXDDD' does not exist.
    We checked it in SQL Server and specified loing exists with sysadmin privilege.

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0x0A2FBD17@1211@1
      Configuration error description: The specified user 'XXXXX@XXXDDD' does not exist.
      Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091019_170504\Detail.txt

      Feature:                       SQL Client Connectivity
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Client Connectivity SDK
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Writer
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Browser
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Failed: see details below
      Configuration error code:      0x0A2FBD17@1211@1

    details log:-
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Action "SqlEngineConfigAction_repair_finalize_Cpu32" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: SqlEngineConfigAction_repair_finalize_Cpu32 The condition tests feature: SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32. There are 10 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32 failed in result Result
    2009-10-19 17:15:08 Slp: Error: Action "SqlEngineConfigAction_repair_finalize_Cpu32" failed during execution.
    2009-10-19 17:15:08 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu32. There are 2 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32 failed in result Result
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Action "ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize The condition tests feature: SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu32. There are 3 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32 failed in result Result
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_SQL_Replication_Core_Inst_sql_engine_core_inst_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Action "ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu32_Repair_Finalize_finalize" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu32_Repair_Finalize_finalize The condition tests feature: SQL_FullText_Adv_sql_fulltext_Cpu32. There are 3 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32 failed in result Result
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_SQL_FullText_Adv_sql_fulltext_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Action "ConfigEvent_Analysis_Server_Full_sql_as_Cpu32_Repair_Finalize_finalize" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: ConfigEvent_Analysis_Server_Full_sql_as_Cpu32_Repair_Finalize_finalize The condition tests feature: Analysis_Server_Full_sql_as_Cpu32. There are 9 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature Analysis_Server_Full_sql_as_Cpu32 failed in result ValidateResult
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_Analysis_Server_Full_sql_as_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Action "ConfigEvent_RS_Server_Adv_sql_rs_Cpu32_Repair_Finalize_finalize" will return false due to the following conditions:
    2009-10-19 17:15:08 Slp: Condition "Feature dependency condition for action: ConfigEvent_RS_Server_Adv_sql_rs_Cpu32_Repair_Finalize_finalize The condition tests feature: RS_Server_Adv_sql_rs_Cpu32. There are 5 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
    2009-10-19 17:15:08 Slp: Condition is false because the required feature RS_Server_Adv_sql_rs_Cpu32 failed in result ValidateResult
    2009-10-19 17:15:08 Slp: Error: Action "ConfigEvent_RS_Server_Adv_sql_rs_Cpu32_Repair_Finalize_finalize" failed during execution.
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_DTS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_DTS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_DTS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_SSMS_Adv
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_PowerShell_Tools_ANS
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = Tools_Legacy_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SDK_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SDK_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SDK_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_SSMS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value Connectivity_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value Connectivity_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = Connectivity_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature configuration state Configured for feature SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey
    2009-10-19 17:15:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
    2009-10-19 17:15:08 Slp: Sco: Attempting to set value SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_BIDS_Full
    2009-10-19 17:15:08 Slp: Completed Action: FinalizeTimingConfigAction, returned True
    2009-10-19 17:15:08 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:08 Slp: Running Action: NotifyProgressComplete
    2009-10-19 17:15:08 Slp: Completed Action: NotifyProgressComplete, returned True
    2009-10-19 17:15:08 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:08 Slp: Running Action: ProduceStatusLogsBeforeFinishPage
    2009-10-19 17:15:09 Slp: Completed Action: ProduceStatusLogsBeforeFinishPage, returned True
    2009-10-19 17:15:09 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:09 Slp: Running Action: FinalizeProgressStatus
    2009-10-19 17:15:09 Slp: Completed Action: FinalizeProgressStatus, returned True
    2009-10-19 17:15:09 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:09 Slp: Running Action: RebootMessageAction
    2009-10-19 17:15:09 Slp: Completed Action: RebootMessageAction, returned True
    2009-10-19 17:15:09 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:09 Slp: Running Action: CloseUI
    2009-10-19 17:15:09 Slp: Stop action skipped in UI Mode Full
    2009-10-19 17:15:09 Slp: Completed Action: CloseUI, returned True
    2009-10-19 17:15:13 Slp:
    2009-10-19 17:15:13 Slp:
    2009-10-19 17:15:13 Slp: ----------------------------------------------------------------------
    2009-10-19 17:15:13 Slp:
    2009-10-19 17:15:13 Slp: Error result: -2068643839
    2009-10-19 17:15:13 Slp: Result facility code: 1203
    2009-10-19 17:15:13 Slp: Result error code: 1
    2009-10-19 17:15:13 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
    2009-10-19 17:15:13 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2009-10-19 17:15:13 Slp: Sco: Attempting to get registry value DW0200
    2009-10-19 17:15:23 Slp: Submitted 1 of 5 failures to the Watson data repository
    2009-10-19 17:15:34 Slp: Detected localization resources folder: 1033
    2009-10-19 17:15:34 Slp: Detected localization resources folder: 1033
    2009-10-19 17:15:34 Slp: Detected localization resources folder: 1033

    • Proposed as answer by Eusebius Tuesday, May 25, 2010 7:40 PM
    Tuesday, October 20, 2009 2:10 PM
  • The specified user 'XXXXX@XXXDDD' does not exis
    Hi,

    Please add the user to Windows Administrators group and add to SQL Logins.

    If you have more questions, please feel free to let us know.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Wednesday, October 21, 2009 6:04 AM
    Moderator
  • Hi ChunSong, The specified user 'XXXXX@XXXDDD'  already existing in windows admin group , sqlserver (sysadmin privilege) and also added in domain admin group too...

    I am guessing,do we need to add or register any where using Setspn  for upgrade??? where can i check ???

    Thanks
    Wednesday, October 21, 2009 2:19 PM
  • Hi,

    If so, you may need to register SPN manually, see this article on Books Online: http://msdn.microsoft.com/en-us/library/ms191153.aspx

    Hope this helps.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, October 22, 2009 6:57 AM
    Moderator
  • Bacause of the time constraint, I have installed the new named instance and moved the settings to new instance.
    Thanks a lot and i appreciate who ever responded.

    Thursday, October 22, 2009 4:44 PM
  • Hi,

    Since you have resolved the problem by installing a new named instance, I am closing this thread. If you have more questions, post new threads, please feel free to let us know.
    ChunSong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Friday, October 23, 2009 9:23 AM
    Moderator
  • This could really use a solution. I've just run into it, and it took me about 2 hours to get the instance back to the point where I could try it again, only to have it fail with the same message. I also received this message when I attempted to install SQL Server 2008 R2 a couple of months ago, so sure doesn't look like it's been resolved. I have exactly the same information in my Details.txt.
    Tuesday, March 16, 2010 7:39 PM
  • I'm having exactly the same issue.

     

    I upgraded a standalone 2005 SP2 instance and it failes at the end of the installation with the xxx@xxxx user does not exist. This is the user that the services run as.

     

    The instance starts OK but hte agent service is still pointing to the 2005 Sp2 files.

     

    It's a shame the thread has been closed as an answer would really be nice.

     

    • Proposed as answer by Eusebius Tuesday, May 25, 2010 7:41 PM
    Thursday, April 29, 2010 11:04 AM
  • I had the same problem. I upgraded a standalone 2005 SP2 instance and it failed at the end of the installation with the xxx@xxxx user does not exist.

    Solution that worked for me:

    In the Services Management Console, I changed the "Log On As" for SQL Server and SQL Server Agent from xxx@xxxx to xxxx\xxx. I didn't change the account. I just changed from the  UPN format (user@fully_qualified_DNS_domain_name) to the domain\username format. For some reason the SQL Server 2008 R2 upgrade doesn't seem to like the UPN format.

    (Sorry for clicking Proposed As Answer for the above. I misread it as Propose An Answer.)
    • Proposed as answer by Eusebius Tuesday, May 25, 2010 7:44 PM
    • Edited by Eusebius Tuesday, May 25, 2010 7:48 PM Explanation of mistake
    Tuesday, May 25, 2010 7:43 PM