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!
