none
sql server 2008 r2 sp2 installation failed RRS feed

  • Question

  • Hi,

    I got a 2-node sql server 2008 R2 failover cluster (64 bit) to patch SP2. One of the node failed with error during sp2 installation as below. Please check and help.

    Overall summary:
      Final result:                  The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068709375
      Exit facility code:            1202
      Exit error code:               1
      Exit message:                  Cannot execute a program. The command being executed was "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Users\cwsmain\AppData\Local\Temp\ebms87n0.cmdline".
      Start time:                    2013-03-07 20:09:53
      End time:                      2013-03-07 20:19:46
      Requested action:              Patch

    Instance MSSQLSERVER overall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068709375
      Exit facility code:            1202
      Exit error code:               1
      Exit message:                  The directory 'f:\275f14ca3bc4000435db3d388419a854\' doesn't exist.
      Start time:                    2013-03-07 20:16:40
      End time:                      2013-03-07 20:18:48
      Requested action:              Patch

    Detail:

    2013-03-07 20:16:00 Slp: Sco: Attempting to get service start mode for service ReportServer
    2013-03-07 20:16:00 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:16:00 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:16:00 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:16:00 Slp: Sco: Returning service status Running
    2013-03-07 20:16:00 Slp: The following NT service was in a running state prior to patch action: ReportServer
    2013-03-07 20:16:00 Slp: Attempting to run patch request for instance: MSSQLSERVER
    2013-03-07 20:18:48 Slp: Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -2068709375)
    2013-03-07 20:18:48 Slp: Sco: Attempting to get service start mode for service SQLBrowser
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:48 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:48 Slp: Sco: Attempting to get service start mode for service SQLBrowser
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:48 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:48 Slp: Restoring the following NT service to a running state after patch action: SQLBrowser
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLBrowser
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLBrowser, start parameters
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLBrowser
    2013-03-07 20:18:48 Slp: Sco: Service SQLBrowser started
    2013-03-07 20:18:48 Slp: Sco: Attempting to get service start mode for service SQLWriter
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:48 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:48 Slp: Sco: Attempting to get service start mode for service SQLWriter
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:48 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:48 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:48 Slp: Restoring the following NT service to a running state after patch action: SQLWriter
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLWriter
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLWriter, start parameters
    2013-03-07 20:18:48 Slp: Sco: Attempting to start service SQLWriter
    2013-03-07 20:18:49 Slp: Sco: Service SQLWriter started
    2013-03-07 20:18:49 Slp: Sco: Attempting to get service start mode for service ReportServer
    2013-03-07 20:18:49 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:49 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:49 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:49 Slp: Sco: Attempting to get service start mode for service ReportServer
    2013-03-07 20:18:49 Slp: Invoking QueryServiceConfig Win32 API for buffer size
    2013-03-07 20:18:49 Slp: Invoking QueryServiceConfig Win32 API with AllocHGlobal buffer
    2013-03-07 20:18:49 Slp: Sco: Returning service start mode Automatic
    2013-03-07 20:18:49 Slp: Restoring the following NT service to a running state after patch action: ReportServer
    2013-03-07 20:18:49 Slp: Sco: Attempting to start service ReportServer
    2013-03-07 20:18:49 Slp: Sco: Attempting to start service ReportServer, start parameters
    2013-03-07 20:18:49 Slp: Sco: Attempting to start service ReportServer
    2013-03-07 20:18:59 Slp: Sco: Service ReportServer started
    2013-03-07 20:18:59 Slp: Completed Action: RunPatchAllInstanceAction, returned True
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ValidatePatchInstanceName due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ExecutePatchCalculateWorkflow due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: FinalCalculateSettings due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ValidateFeatureSettings due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: AddPackageInstallerEnginesAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: SchedulePackageInstallActionsAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ScheduleUpgradePackageInstallActionsAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: NotifyProgressCountDisplay due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ScheduleConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: ValidationTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: PreMsiTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: StopPatchedServices due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: CachePatchPage due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: InitializeMsiAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: MsiTimingAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: FinalizeMsiAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: PostMsiTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: DowntimeTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: StartPatchedServices due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: StartupTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: PreUninstallTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: UninstallTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: UpgradeMsiTimingAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: FinalizeTimingConfigAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: CreateARPRegKeyAction due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Skipping Action: NotifyProgressComplete due to user cancel request
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Running Action: FinalizeProgressStatus
    2013-03-07 20:18:59 Slp: Completed Action: FinalizeProgressStatus, returned True
    2013-03-07 20:18:59 Slp: ----------------------------------------------------------------------
    2013-03-07 20:18:59 Slp: Running Action: CloseUI
    2013-03-07 20:18:59 Slp: Stop action skipped in UI Mode Full
    2013-03-07 20:18:59 Slp: Completed Action: CloseUI, returned True
    2013-03-07 20:19:00 Slp: Received request to add the following file to Watson reporting: C:\Users\cwsmain\AppData\Local\Temp\tmp29B5.tmp
    2013-03-07 20:19:00 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2013-03-07 20:19:00 Slp: Inner exceptions are being indented
    2013-03-07 20:19:00 Slp:
    2013-03-07 20:19:00 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
    2013-03-07 20:19:00 Slp:     Message:
    2013-03-07 20:19:00 Slp:         Cannot execute a program. The command being executed was "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Users\cwsmain\AppData\Local\Temp\ebms87n0.cmdline".
    2013-03-07 20:19:00 Slp:     Stack:
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type, String elementXPath)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.GetInputSettingValue(String settingName)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.StatusLogs.WriteInputSettings(LogProviderSummaryFile summaryLog)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.StatusLogs.WritePatchSummaryLog(Int32 resultCode, Exception exception)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.StatusLogs.WriteSummaryLog(Int32 resultCode, Boolean finalResult, Exception exception)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.WriteStatusLogs(Int32 resultCode, Exception e)
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Start()
    2013-03-07 20:19:00 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Main()
    2013-03-07 20:19:00 Slp:     Inner exception type: System.Runtime.InteropServices.ExternalException
    2013-03-07 20:19:00 Slp:         Message:
    2013-03-07 20:19:00 Slp:                 Cannot execute a program. The command being executed was "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Users\cwsmain\AppData\Local\Temp\ebms87n0.cmdline".
    2013-03-07 20:19:00 Slp:         Stack:
    2013-03-07 20:19:00 Slp:                 at System.CodeDom.Compiler.Executor.ExecWaitWithCaptureUnimpersonated(SafeUserTokenHandle userToken, String cmd, String currentDir, TempFileCollection tempFiles, String& outputName, String& errorName, String trueCmdLine)
    2013-03-07 20:19:00 Slp:                 at System.CodeDom.Compiler.Executor.ExecWaitWithCapture(SafeUserTokenHandle userToken, String cmd, String currentDir, TempFileCollection tempFiles, String& outputName, String& errorName, String trueCmdLine)
    2013-03-07 20:19:00 Slp:                 at Microsoft.CSharp.CSharpCodeGenerator.Compile(CompilerParameters options, String compilerDirectory, String compilerExe, String arguments, String& outputFile, Int32& nativeReturnValue, String trueArgs)
    2013-03-07 20:19:00 Slp:                 at Microsoft.CSharp.CSharpCodeGenerator.FromFileBatch(CompilerParameters options, String[] fileNames)
    2013-03-07 20:19:00 Slp:                 at Microsoft.CSharp.CSharpCodeGenerator.FromSourceBatch(CompilerParameters options, String[] sources)
    2013-03-07 20:19:00 Slp:                 at Microsoft.CSharp.CSharpCodeGenerator.System.CodeDom.Compiler.ICodeCompiler.CompileAssemblyFromSourceBatch(CompilerParameters options, String[] sources)
    2013-03-07 20:19:00 Slp:                 at System.CodeDom.Compiler.CodeDomProvider.CompileAssemblyFromSource(CompilerParameters options, String[] sources)
    2013-03-07 20:19:00 Slp:                 at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)
    2013-03-07 20:19:00 Slp:                 at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies)
    2013-03-07 20:19:00 Slp:                 at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)
    2013-03-07 20:19:00 Slp:                 at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping xmlMapping, Type type, String defaultNamespace)
    2013-03-07 20:19:00 Slp:                 at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace)
    2013-03-07 20:19:00 Slp:                 at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject(String rootPath, Type type, String elementXPath)
    2013-03-07 20:19:45 Slp: Watson Bucket 1
     Original Parameter Values

    2013-03-07 20:19:45 Slp: Parameter 0 : SQL2008@RTM@KB2630458

    2013-03-07 20:19:45 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.DeserializeObject

    2013-03-07 20:19:45 Slp: Parameter 2 : System.CodeDom.Compiler.Executor.ExecWaitWithCaptureUnimpersonated

    2013-03-07 20:19:45 Slp: Parameter 3 : Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException@1201@1

    2013-03-07 20:19:45 Slp: Parameter 4 : System.Runtime.InteropServices.ExternalException@267

    2013-03-07 20:19:45 Slp:
     Final Parameter Values

    2013-03-07 20:19:45 Slp: Parameter 0 : SQL2008@RTM@KB2630458

    2013-03-07 20:19:45 Slp: Parameter 1 : 0x055C02AC

    2013-03-07 20:19:45 Slp: Parameter 2 : 0x86203738

    2013-03-07 20:19:45 Slp: Parameter 3 : 0xDF039760@1201@1

    2013-03-07 20:19:45 Slp: Parameter 4 : 0xD95CEA3F

    2013-03-07 20:19:45 Slp: The following exception occurred while preparing status logs during Watson failure processing: Cannot execute a program. The command being executed was "C:\Windows\Microsoft.NET\Framework64\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Users\cwsmain\AppData\Local\Temp\edxytlec.cmdline".
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2013-03-07 20:19:45 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130307_200912\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2013-03-07 20:19:46 Slp: The following exception occurred during Watson failure processing: The directory is not empty.

    2013-03-07 20:19:46 Slp:
    2013-03-07 20:19:46 Slp: ----------------------------------------------------------------------
    2013-03-07 20:19:46 Slp:
    2013-03-07 20:19:46 Slp: Error result: -2068774911
    2013-03-07 20:19:46 Slp: Result facility code: 1201
    2013-03-07 20:19:46 Slp: Result error code: 1
    2013-03-07 20:19:46 Slp:
    2013-03-07 20:19:46 Slp: ----------------------------------------------------------------------
    2013-03-07 20:19:46 Slp:
    2013-03-07 20:19:46 Slp: Error result: -2068774911
    2013-03-07 20:19:46 Slp: Result facility code: 1201
    2013-03-07 20:19:46 Slp: Result error code: 1

    Friday, March 8, 2013 9:42 AM

Answers

  • Can you try renaming temp folder

    C:\Users\cwsmain\AppData\Local\Temp\

    also repairing .NET framework.


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Marked as answer by moewmoew Tuesday, April 9, 2013 6:34 AM
    Monday, March 11, 2013 6:45 AM
    Moderator

All replies

  • Hello,

    Please extract the content of the service pack/update to a local drive on that server using the /X switch and run setup program from there.


    The following resource may help:

    http://connect.microsoft.com/SQLServer/feedback/details/645972/sql-server-2008-r2-cumulative-update-setup-process-wrong-for-failover-cluster

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, March 8, 2013 11:03 AM
    Moderator
  • Are you running setup under administrative privileges ?


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Sunday, March 10, 2013 11:57 AM
    Moderator
  • Hi Ahmed,

    Thanks for your reply. Yes, the setup was run under administrative privileges according to the installer "system configuration check report".

    ThreadHasAdminPrivilegeCheck => Passed

    Monday, March 11, 2013 3:53 AM
  • Hi Alberto,

    Thanks for the advice. The patch installation failed when the node (NODE) was active with the clustered drive mounted, which was the case I posted before. However, when I tried to patch the same node (NODE) as passive without the clustered drive, there was another error as below. FYI, another node "NODE2" was patched successfully. Please help.

    Overall summary:
      Final result:                  The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.

    Instance MSSQLSERVER overall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068578304
      Exit facility code:            1204
      Exit error code:               0
      Exit message:                  The SQL Server failover cluster instance 'MSSQLSERVER' was not correctly detected. The instance was discovered on the local node but it was not found to be active. To continue, confirm the state of the instance installed on all applicable nodes of the cluster and the state of the failover cluster resources.

    Cluster properties:
      Machine name: NODE
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Edition   10.50.1600.1    Yes       
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    Yes       
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    Yes       
      Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Enterprise Edition   10.50.1600.1    Yes       
      Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        
      Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Edition   10.50.1600.1    No        

      Machine name: NODE2
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

    <empty>

    Detail.txt:

    2013-03-07 19:00:17 Slp: ----------------------------------------------------------------------
    2013-03-07 19:00:17 Slp: Skipping property InstallMediaPath of class: InitializeMsiExtension
    2013-03-07 19:00:17 Slp: Input of property will not be set due to the following failed restriction(s):
    2013-03-07 19:00:17 Slp: Condition "Is the datastore flag /Scenario/GlobalFlags/IsMediaRequired set" did not pass as it returned false and true was expected.
    2013-03-07 19:00:17 Slp: ----------------------------------------------------------------------

    ...

    2013-03-07 19:00:19 Slp: Running Action: RunDiscoveryAction
    2013-03-07 19:00:19 Slp: Running discovery on local machine
    2013-03-07 19:00:43 Slp: Discovery on local machine is complete
    2013-03-07 19:00:43 Slp: Running discovery on remote machine: NODE2
    2013-03-07 19:00:43 Slp: Discovery on NODE2 failed due to exception
    2013-03-07 19:00:43 Slp: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: Attempted to perform an unauthorized operation. ---> System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
       at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.CreateBaseKey(ServiceContainer ctx, String machineName, IntPtr hKey, String keyName, RegistryAccess access, RegistryView view)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.CreateBaseKey(ServiceContainer ctx, String machineName, IntPtr hKey, String keyName, RegistryAccess access, RegistryView view)
       at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocalMachine(ServiceContainer ctx, String machineName, RegistryAccess access, RegistryView view)
       at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetSql2kMsiInstanceListInHive(String machineName, RegistryView regView)
       at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.LoadSql2kInstanceList(String machineName)
       at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
       at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
       --- End of inner exception stack trace ---
       at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.ProcessDTbl(DataTable dt, Int32 level)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectSqlDiscoveryData(String machineName)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectDiscoveryData(String machineName)
       at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
    2013-03-07 19:00:43 Slp: Discovery failed due to access denied, setup will continue running.
    2013-03-07 19:00:43 Slp: Completed Action: RunDiscoveryAction, returned True
    2013-03-07 19:00:43 Slp: ----------------------------------------------------------------------
    2013-03-07 19:00:43 Slp: Skipping Action: GetInstanceNameByInstanceIdAction
    2013-03-07 19:00:43 Slp: Action is being skipped due to the following restrictions:
    2013-03-07 19:00:43 Slp: Condition "IsTrue" did not pass as it returned false and true was expected.
    2013-03-07 19:00:44 Slp: ----------------------------------------------------------------------

    ...

    2013-03-07 19:03:29 Slp: Attempting to run patch request for instance: MSSQLSERVER
    2013-03-07 19:05:22 Slp: Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -2068578304)

    ...

    Monday, March 11, 2013 4:22 AM
  • Can you try renaming temp folder

    C:\Users\cwsmain\AppData\Local\Temp\

    also repairing .NET framework.


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Marked as answer by moewmoew Tuesday, April 9, 2013 6:34 AM
    Monday, March 11, 2013 6:45 AM
    Moderator
  • Hi Ahmed,

    Thanks. The problem has been fixed after renaming the Temp folder and re-running the installer.

    Moew

    Tuesday, April 9, 2013 6:36 AM
  • Similar issue faced on DR site which was having storage replication from Prod Issue fixed by taking a new snapshot from Prod to Dr server and then trying the patch installation . Maybe the earlier snapshot was not correct/corrupted My blog : www.abhishekdwivedisite.wordpress.com
    Sunday, July 21, 2019 5:00 AM