Код ошибки 0x876e0003 sql server

• Remove From My Forums

• Question

• Good Day

  I am trying to install SQL 2012.

  during the installation process it halts and I receive the following message:

  TITLE: SQL Server Setup failure.
  ——————————

  SQL Server Setup has encountered the following error:

  Setup encountered a failure while running job UpdateResult.

  Error code 0x876E0003.

  I have spent hours looking through help blogs and other resources trying to find answers and help but have not been able to find a solution..!

  Any advise or how to work around this would be greatly appreciated!

  Thank you.

• Remove From My Forums

Installation error with SQL Express 2014 — Setup encountered a failure while running job UpdateResult

• Вопрос

• I am trying to do a command line install of SQL Express, using the command:

  .Setup.exe /q /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT=»NT AUTHORITYSYSTEM» /IACCEPTSQLSERVERLICENSETERMS=1 /SECURITYMODE=SQL /SAPWD={{sa_password}} /TCPENABLED=1

  where {{ sa_password }} gets the password substituted in at run time by Ansible.  When I run this command at the command line, it works.  When I run under Ansible, I get the following error:

  <style type=»text/css»>p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #c33720} span.s1 {font-variant-ligatures: no-common-ligatures} </style>

  «The following error occurred:rnSetup encountered a failure while running job UpdateResult.rnrnError result: -2022834173rnResult facility code: 1902rnResult error code: 3rnrnPlease review the summary.txt log for further detailsrnMicrosoft
  (R) SQL Server 2014 12.00.2000.08rrnCopyright (c) Microsoft Corporation.  All rights reserved.rrnrn», «stdout_lines»: [«The following error occurred:», «Setup encountered a failure while running job UpdateResult.»,
  «», «Error result: -2022834173», «Result facility code: 1902», «Result error code: 3», «», «Please review the summary.txt log for further details»

  The summary.txt file has no error messages in it.  Google has no references to this message.  Does anyone know what is happening here?

  Thanks.

• Remove From My Forums

• Question

• Hi All,

  I have a SQL server failover cluster installation, the cluster installs fine on the firs node, however when adding a new node to the cluster the installation fails due to the following error.

  I am aware that this has been covered in the post here (http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d0800ccf-5ade-471c-8942-b7d43031478b/sql-2012-installation-error)
  and adding the flag
  UpdateEnabled=False

  does indeed fix the problem, but it leaves the cluster in an unstable state, where one node has the intended service pack update and the other node doesnt. What I am looking for is the root cause to the problem and also a solution that does not involve UpdateEnabled
  = false.

  Thanks in advance.

  Overall summary:
    Final result:                  Failed: see details below
    Exit code (Decimal):           -2022834173
    Exit facility code:            1902
    Exit error code:               3
    Exit message:                  Setup encountered a failure while running job UpdateResult.
    Start time:                    2014-06-03 13:46:29
    End time:                      2014-06-03 13:46:48
    Requested action:              ComponentUpdate
    Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0xF4B846A1%400xBB814387&EvtType=0xF4B846A1%400xBB814387
  
  Machine Properties:
    Machine name:                  UKFIL1840WINC1
    Machine processor count:       40
    OS version:                    Windows Server 2008 R2
    OS service pack:               Service Pack 1
    OS region:                     United Kingdom
    OS language:                   English (United States)
    OS architecture:               x64
    Process architecture:          64 Bit
    OS clustered:                  Yes
  
  Package properties:
    Description:                   Microsoft SQL Server 2012 Service Pack 1
    ProductName:                   SQL Server 2012
    Type:                          RTM
    Version:                       11
    Installation location:         S:2012_enterprise_edition_sp1x64setup
    Installation edition:          Enterprise
  
    Slipstream:                    True
  
  Product Update Status:
    Failure to check for updates.
    Error message:
  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.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)
  
  
  User Input Settings:
    ACTION:                        ComponentUpdate
    CONFIGURATIONFILE:             
    ENU:                           true
    HELP:                          false
    IACCEPTSQLSERVERLICENSETERMS:  true
    INDICATEPROGRESS:              false
    PID:                           *****
    QUIET:                         true
    QUIETSIMPLE:                   false
    SQMREPORTING:                  false
    UIMODE:                        Normal
    X86:                           false
  
    Configuration file:            C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140603_134606ConfigurationFile.ini
  
  Rules with failures:
  
  Global rules:
  
  There are no scenario-specific rules.
  
  Rules report file:               C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140603_134606SystemConfigurationCheck_Report.htm
  
  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)
  

  The contents of one of the files in the installation log is as follows.

  • Edited by

    Tuesday, June 3, 2014 2:46 PM

• Remove From My Forums

• Question

• Hi All,

  I have a SQL server failover cluster installation, the cluster installs fine on the firs node, however when adding a new node to the cluster the installation fails due to the following error.

  I am aware that this has been covered in the post here (http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d0800ccf-5ade-471c-8942-b7d43031478b/sql-2012-installation-error)
  and adding the flag
  UpdateEnabled=False

  does indeed fix the problem, but it leaves the cluster in an unstable state, where one node has the intended service pack update and the other node doesnt. What I am looking for is the root cause to the problem and also a solution that does not involve UpdateEnabled
  = false.

  Thanks in advance.

  Overall summary:
    Final result:                  Failed: see details below
    Exit code (Decimal):           -2022834173
    Exit facility code:            1902
    Exit error code:               3
    Exit message:                  Setup encountered a failure while running job UpdateResult.
    Start time:                    2014-06-03 13:46:29
    End time:                      2014-06-03 13:46:48
    Requested action:              ComponentUpdate
    Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0xF4B846A1%400xBB814387&EvtType=0xF4B846A1%400xBB814387
  
  Machine Properties:
    Machine name:                  UKFIL1840WINC1
    Machine processor count:       40
    OS version:                    Windows Server 2008 R2
    OS service pack:               Service Pack 1
    OS region:                     United Kingdom
    OS language:                   English (United States)
    OS architecture:               x64
    Process architecture:          64 Bit
    OS clustered:                  Yes
  
  Package properties:
    Description:                   Microsoft SQL Server 2012 Service Pack 1
    ProductName:                   SQL Server 2012
    Type:                          RTM
    Version:                       11
    Installation location:         S:2012_enterprise_edition_sp1x64setup
    Installation edition:          Enterprise
  
    Slipstream:                    True
  
  Product Update Status:
    Failure to check for updates.
    Error message:
  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.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)
  
  
  User Input Settings:
    ACTION:                        ComponentUpdate
    CONFIGURATIONFILE:             
    ENU:                           true
    HELP:                          false
    IACCEPTSQLSERVERLICENSETERMS:  true
    INDICATEPROGRESS:              false
    PID:                           *****
    QUIET:                         true
    QUIETSIMPLE:                   false
    SQMREPORTING:                  false
    UIMODE:                        Normal
    X86:                           false
  
    Configuration file:            C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140603_134606ConfigurationFile.ini
  
  Rules with failures:
  
  Global rules:
  
  There are no scenario-specific rules.
  
  Rules report file:               C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140603_134606SystemConfigurationCheck_Report.htm
  
  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)
  

  The contents of one of the files in the installation log is as follows.

  • Edited by

    Tuesday, June 3, 2014 2:46 PM

1. hi, how did u do it. i believe i ran into the same issue like you. setting up autocount on parallels.

2. Following this thread every day as I would love to buy a new Mac Studio, but am currently using SQL Server 2017 + Visual Studio 2019 and will wait until it’ll be possible to run them on an M1.
   BTW: any news if SQL Server 2022 will be arm-compatible or not?

3. SQL Server 2022 is not going to support ARM64, based on what I asked from Microsoft SQL Server 2022 guys.

4. Thanks, this is not good news unfortunately. As a VS2019 .net 4.7 + Sql Server 2019 developer, I was really looking forward to upgrading my current iMac 27″ 2016, but it looks like a long way to go atm.

5. Amigo aun tienes el archivo que me puedas ayudar enviando, mediante wetransfer?

6. Hello, I am trying to setup SQL Server 2019 Setup on
   OS — Windows11_InsiderPreview_Client_ARM64_en-us_22579
   From the links mentioned in the threads, I have tried downloading every Cumulative Update Package (10, 12, 14, 15) for SQL Server 2019, but none of them work.
   

7. Hello MarcosW, Please refer to the knowledge base https://kb.parallels.com/9058 article to generate a technical report Id. Thanks.

8. Thanks for that, with 2014 32-bit works for me.

9. >>> Message has been deleted by the user <<<

10. Hola estoy tratando de instalar el SQL Server express 2019 en mi mac m1 con parallels en windows 10 qu elos descargue de aqui, por si alguien lo necesita: Windows 10 ARM Insider Preview VHDX File [Solved] : windowsinsiders (reddit.com), pero no me ha funcionado, cual de las tres opciones de sql server tengo que instalar, despues de instalar el Update?. Saludos.

11. The non-existent support from Parallels. I expect active help until the problem is solved. This is what I pay for. But nothing happens. I have cancelled my subscription and all other customers should do the same. Parallels Desktop has become useless to me on the M1.

12. I’m also in this situation but I realise that this is no fault of Parallels! You should turn your anger towards Microsoft for not supporting this newer version of SQL-server on Windows for ARM. Unfortunately it’s futile to complain to MS and the only thing we can do is wait. I myself are looking for an Intel Mac to solve the problem temporarily.

13. Mirror above posters with similar significant issue.

14. I think I would be ok with Sql Server LocalDB working correctly for development. I seem to be able to connect to localdb from within SSMS and also Visual Studio server explorer, but EF Core Migrations can’t seem to find the server when running update-database. Anyone else encounter this?

15. I have an M1 Mac with windows 11 installed. I tried following the instructions but the install fails:

    TITLE: SQL Server Setup failure.
    ——————————

    SQL Server Setup has encountered the following error:

    Setup encountered a failure while running job UpdateResult.

    Error code 0x876E0003.

    For help, click: https://go.microsoft.com/fwlink?Lin…l&EvtID=50000&EvtType=0x448E4A06%400x96D07230

    ——————————
    BUTTONS:

    OK
    ——————————

    Any pointers on how to get it installed? Is it even possible?

16. For those still struggling to install MS SQL 2019 on Windows 11 I’ve found a way with a combinationa of things posted on this forum.
    Steps:

    1. Obtain Windows 10 build 21354 following instructions on this link (thanks MarcosH2) https://www.reddit.com/r/windowsins…dows_10_arm_insider_preview_vhdx_file_solved/
    This step is very important as no other builds worked for me.

    2. Install Windows 10. Important — select to configure VM before installing and remove ‘TPM Chip’ from Hardware as it’s not compatible with Windows 10.

    3. Follow instructions on installing and updating SQL 2019 from the very first post on this thread (thanks Mundford) — I first installed SQL 2019 developers edition (free) which failed as usual, then updated with both links provided, then installed SQL 2019 again and it worked!

    4. Update to Windows 11. Windows updates didn’t work for me, so I first updated to latest Windows 10 build available (21390) using ISO image.
    Important — you have to add TPM Chip back or Windows 11 won’t install. Again I couldn’t update to Windows 11 from updates, so I got Windows 11 build 22000 ISO and updated without problems.

    5. After upgrading to Windows 11 updates are working fine again so updating to very latest build right now. SQL Management Studio still works no issues.

    Hopefully this will help someone as well.

17. OK, some bad news. While I was able to install SQL 2019 as per above, SQL Server Network Configuration node is missing from Configuration Manager so can’t connect from my apps.

    Couldn’t find any solutions on internet either

18. Has anyone already tried Parallels 18 and SQL-Server 2019 on M1??
    They mention SQL-Server under «lightning fast»

    Attached Files:

    • 

19. What a great timing re Parallels 18, hopefully SQL 2019 installs without issues.

20. I have tried and the installation failed (SQL 2019 Developer Edition)

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Sue_H

SSC Guru

Points: 90860

Did you ever figure this out? I hit the same error many version before so I was curious about this. I had to uninstall and reinstall VS. It worked but I have no idea why.
I was just searching on it and believe I found your other post maybe — followed by some obnoxious person who said they would do whatever they want with posts. Wow….that person is a total <will only get deleted if I say what I think>. Pretty sure that was you — sorry that happened.  Sorrier that I don’t have an answer. 

Sue

Thom A

SSC Guru

Points: 99071

Sue_H

SSC Guru

Points: 90860

That’s pretty much the same as what I ran into before. I wish I knew what the issue is with this. I haven’t seen a good answer on it anywhere. 🙁

Sue

andybrown22

SSC Journeyman

Points: 83

I know this is an old post but thought I’d post what I found today whilst encountering the exact same issue in case it helps someone else

Error 0x80070001: Process returned error: 0x1
Error 0x80070001: Failed to execute EXE package.
Error 0x80070001: Failed to configure per-machine EXE package.
MainViewModel.OnPackageAction: Install Completed for package Update Visual Studio Installer (id: VS_SQL_UpdateInstaller)
Applied execute package: VS_SQL_UpdateInstaller, result: 0x80070001, restart: None
Error 0x80070001: Failed to execute EXE package.

The installer log file doesnt really give any information of what is wrong however there is another log file for the VS_SQL_UpdateInstaller package which outlined the issue (TLS).

The other log file shows the following
VSSqlBootstrapper.exe Information: 0 : Try to download vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe. Retry count: 0
VSSqlBootstrapper.exe Error: 0 : Download failed with exception System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. —> System.ComponentModel.Win32Exception: The client and server cannot communicate, because they do not possess a common algorithm

The log file is located in C:UsersxxxxxxAppDataLocalTempSsdtSetup and is in the format «SSDT-Setup-ENU_nnnnnnnnnnnnnnn_nnn_VS_SQL_UpdateInstaller.log»

To resolve the issue I did the following
1. Manually downloaded and installed vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe
2. Launch SSDT-Setup-ENU.exe de-select SSAS, RS and IS (only database services)
3. Uninstall/Change (Control Panel) — «Microsoft SQL Server Data Tools — Visual Studio 2017»
4. Modify
5. Select required components AS/RS/IS
6. Install

Hope that helps

andybrown22 wrote:

I know this is an old post but thought I’d post what I found today whilst encountering the exact same issue in case it helps someone else

Error 0x80070001: Process returned error: 0x1

Error 0x80070001: Failed to execute EXE package.

Error 0x80070001: Failed to configure per-machine EXE package.

MainViewModel.OnPackageAction: Install Completed for package Update Visual Studio Installer (id: VS_SQL_UpdateInstaller)

Applied execute package: VS_SQL_UpdateInstaller, result: 0x80070001, restart: None

Error 0x80070001: Failed to execute EXE package.

The installer log file doesnt really give any information of what is wrong however there is another log file for the VS_SQL_UpdateInstaller package which outlined the issue (TLS).

The other log file shows the following

VSSqlBootstrapper.exe Information: 0 : Try to download vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe. Retry count: 0

VSSqlBootstrapper.exe Error: 0 : Download failed with exception System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. —> System.ComponentModel.Win32Exception: The client and server cannot communicate, because they do not possess a common algorithm

The log file is located in C:UsersxxxxxxAppDataLocalTempSsdtSetup and is in the format «SSDT-Setup-ENU_nnnnnnnnnnnnnnn_nnn_VS_SQL_UpdateInstaller.log»

To resolve the issue I did the following

1. Manually downloaded and installed vs_sql.exe from https://aka.ms/vs/15/release/vs_sql.exe

2. Launch SSDT-Setup-ENU.exe de-select SSAS, RS and IS (only database services)

3. Uninstall/Change (Control Panel) — «Microsoft SQL Server Data Tools — Visual Studio 2017»

4. Modify

5. Select required components AS/RS/IS

6. Install

Hope that helps