Answered by:
Install SQL Server 2012 remote

-
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!
Question
Answers
All replies
-
-
-
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?
-