none
Install SQL Server 2012 remote

    Question

  • Hi,

    I am trying to install SQL Server 2012 in PowerShell 3.0 using a PSSession. This all works, I can install all kinds of software but I keep having problems with SQL Server 2012. When I execute my code on SourceComputer, the installation starts at the TargetComputer (I can see this in the process monitor). After 20 seconds the installation suddenly quiet. When I look in the log directory in the summary file, I see the following error:

    ---------------------------------------------------------------------

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.ExtensionCommon.JobExecutionException
        Message: 
            Setup encountered a failure while running job UpdateResult.
        HResult : 0x876e0003
            FacilityCode : 1902 (76e)
            ErrorCode : 3 (0003)
        Data: 
          JobId = UpdateResult
          WatsonData = Microsoft.SqlServer.Chainer.ExtensionCommon.JobExecutionException@3
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Chainer.ExtensionCommon.WaitForAsyncAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
        Inner exception type: Microsoft.SqlServer.Chainer.ExtensionCommon.AsyncWorkflowExecutionException
            Message: 
                    Setup encountered an unexpected failure when trying to run workflow SEARCHUPDATES.
            HResult : 0x876e0001
                    FacilityCode : 1902 (76e)
                    ErrorCode : 1 (0001)
            Data: 
              WorkflowId = SEARCHUPDATES
              WatsonData = Microsoft.SqlServer.Chainer.ExtensionCommon.AsyncWorkflowExecutionException@1
            Inner exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException
                Message: 
                            Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
                HResult : 0x84b30001
                            FacilityCode : 1203 (4b3)
                            ErrorCode : 1 (0001)
                Data: 
                  SQL.Setup.FailureCategory = ActionFailure
                  DisableWatson = true
                Stack: 
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
                            at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
                            at Microsoft.SqlServer.Chainer.ExtensionCommon.ExecuteWorkflowAsyncAction.JobStart()
                Inner exception type: System.UnauthorizedAccessException
                    Message: 
                                    Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
                    HResult : 0x80070005
                    Stack: 
                                    at Microsoft.SqlServer.Configuration.SmartSetupExtension.MuSearchUtility.TrySearch(String serviceId, String query)
                                    at Microsoft.SqlServer.Configuration.SmartSetupExtension.MuSearchEngine.Search(String serviceId, String query)
                                    at Microsoft.SqlServer.Configuration.SmartSetupExtension.MuSetupSearchEngine.SearchUpdates()
                                    at Microsoft.SqlServer.Configuration.SmartSetupExtension.SearchUpdatesAction.ExecuteAction(String actionId)
                                    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
                                    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)

    ------------------------------------------------------

    What is SQL Server trying to do? Where does he get this Access Denied error and which credentials is he using? Any help would be greatly appreciated!

    Monday, November 25, 2013 4:28 PM

Answers

  • Please try running the installation again but make sure that updateenabled is set to false.

    UPDATEENABLED="False"

    Please let me know how it went.

    Regards,

    G-P

    • Marked as answer by RonaldALM Tuesday, November 26, 2013 9:04 AM
    Monday, November 25, 2013 10:22 PM

All replies

  • Hi,

    Please add more details on how you install SQL. (Config file\CMD\etc...)

    Regards,

    G-P

    Monday, November 25, 2013 10:15 PM
  • Please try running the installation again but make sure that updateenabled is set to false.

    UPDATEENABLED="False"

    Please let me know how it went.

    Regards,

    G-P

    • Marked as answer by RonaldALM Tuesday, November 26, 2013 9:04 AM
    Monday, November 25, 2013 10:22 PM
  • By adding "/UpdateEnabled="False"" it does work. Default this setting is set to True. So for some reason (without specifying /UpdateSource) it does not work because of an Access Denied. We do use a WSUS server for Windows Updates and by default /UpdateSource looks at Microsoft Update. Can I solve this problem by changing permissions somewhere? Why do I get an Access Denied when using Microsoft Update?
    Tuesday, November 26, 2013 9:04 AM
  • I encountered the same issue because I used this parameter, but without using all the letter as capitals and it failed with the same error.
    Wednesday, January 17, 2018 4:16 PM