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

Answers

• Hi BrendanDev,

  According to the error message, the issue may occur due to the permission issue with Windows update.

   
  In this case, If you have the DefaultSetup.ini file in the x86 or x64 folders at the root level of the SQL Server source media, please open the DefaultSetup.ini file, and then add the UpdateEnabled or UpdateSource parameters to the file. If the DefaultSetup.ini
  file does not exist, we can create it and copy it to the x86 and x64 folders at the root level of the SQL Server source media. And then we need to modify the «DefaultSetup.ini» file and set the switch «UpdateEnabled=False» which skips the product updates
  in the installation.

  For the detailed information, please refer to the link below:
  http://blogs.msdn.com/b/petersad/archive/2011/07/13/product-update-in-sql-server-code-named-denali.aspx

  If you need more assistance, please feel free to let me know. 

  Regards,
  Heidi Duan

  • Proposed as answer by

    Sunday, September 1, 2013 8:02 AM

  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

• Its seems like .NET component issue, Please uninstall the .NET framework and re-install again.

  If issue still there then post text of summary.text which is at ProgramFilesMicrosoft SQL Server110Setup BootstrapLog folder.

  Go through the below link before installation

  http://msdn.microsoft.com/en-us/library/bb500469.aspx

  • Edited by
    Pradeep Madheshiya Microsoft(MSFT)
    Monday, August 19, 2013 7:41 AM
    help
  • Proposed as answer by
    Ed Price — MSFTMicrosoft employee
    Sunday, September 1, 2013 8:02 AM
  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

Ответы

• I found an answer through using the following code to surround the install command.  The values inside the braces are substituted by Ansible at runtime 

  $username = ‘administrator’

  $password = ‘{{admin_password}}’

  $securePassword = ConvertTo-SecureString $password -AsPlainText -Force

  $credential = New-Object System.Management.Automation.PSCredential $username, $securePassword

  Start-Process -FilePath c:UsersAdministratorworkSQLEXPR_x64_ENUSetup.exe -Argumentlist ‘/q /ACTION=Install /FEATURES=SQLEngine /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT=»NT AUTHORITYSYSTEM» /IACCEPTSQLSERVERLICENSETERMS=1 /SECURITYMODE=SQL /SAPWD=»{{sa_password}}»
  /TCPENABLED=1 /UPDATEENABLED=»False»‘ -NoNewWindow -Credential $credential

  • Помечено в качестве ответа

    8 июня 2017 г. 15:54
  • Изменено
    Andrew Brunette
    8 июня 2017 г. 15:54
    clarifying

I am facing an error while trying to install SQL Server 2012 EXPRESS ADVANCED EDITION(32bit) on Windows Server 2008 Enterprise(64bit).

After passing Rule Check, at install updates section, error occurs about update could not be downloaded. On clicking next, following error in dialog box occurs.

SQL Server Setup has encountered the following error:

Setup encountered a failure while running job UpdateResult.

Error code 0x876E0003.

How can I solve this?

asked Jan 7, 2016 at 3:28

Answers

• Hi BrendanDev,

  According to the error message, the issue may occur due to the permission issue with Windows update.

   
  In this case, If you have the DefaultSetup.ini file in the x86 or x64 folders at the root level of the SQL Server source media, please open the DefaultSetup.ini file, and then add the UpdateEnabled or UpdateSource parameters to the file. If the DefaultSetup.ini
  file does not exist, we can create it and copy it to the x86 and x64 folders at the root level of the SQL Server source media. And then we need to modify the «DefaultSetup.ini» file and set the switch «UpdateEnabled=False» which skips the product updates
  in the installation.

  For the detailed information, please refer to the link below:
  http://blogs.msdn.com/b/petersad/archive/2011/07/13/product-update-in-sql-server-code-named-denali.aspx

  If you need more assistance, please feel free to let me know. 

  Regards,
  Heidi Duan

  • Proposed as answer by

    Sunday, September 1, 2013 8:02 AM

  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

• Its seems like .NET component issue, Please uninstall the .NET framework and re-install again.

  If issue still there then post text of summary.text which is at ProgramFilesMicrosoft SQL Server110Setup BootstrapLog folder.

  Go through the below link before installation

  http://msdn.microsoft.com/en-us/library/bb500469.aspx

  • Edited by
    Pradeep Madheshiya Microsoft(MSFT)
    Monday, August 19, 2013 7:41 AM
    help
  • Proposed as answer by
    Ed Price — MSFTMicrosoft employee
    Sunday, September 1, 2013 8:02 AM
  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

Answers

• Hi BrendanDev,

  According to the error message, the issue may occur due to the permission issue with Windows update.

   
  In this case, If you have the DefaultSetup.ini file in the x86 or x64 folders at the root level of the SQL Server source media, please open the DefaultSetup.ini file, and then add the UpdateEnabled or UpdateSource parameters to the file. If the DefaultSetup.ini
  file does not exist, we can create it and copy it to the x86 and x64 folders at the root level of the SQL Server source media. And then we need to modify the «DefaultSetup.ini» file and set the switch «UpdateEnabled=False» which skips the product updates
  in the installation.

  For the detailed information, please refer to the link below:
  http://blogs.msdn.com/b/petersad/archive/2011/07/13/product-update-in-sql-server-code-named-denali.aspx

  If you need more assistance, please feel free to let me know. 

  Regards,
  Heidi Duan

  • Proposed as answer by

    Sunday, September 1, 2013 8:02 AM

  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

• Its seems like .NET component issue, Please uninstall the .NET framework and re-install again.

  If issue still there then post text of summary.text which is at ProgramFilesMicrosoft SQL Server110Setup BootstrapLog folder.

  Go through the below link before installation

  http://msdn.microsoft.com/en-us/library/bb500469.aspx

  • Edited by
    Pradeep Madheshiya Microsoft(MSFT)
    Monday, August 19, 2013 7:41 AM
    help
  • Proposed as answer by
    Ed Price — MSFTMicrosoft employee
    Sunday, September 1, 2013 8:02 AM
  • Marked as answer by
    Shanky_621MVP
    Wednesday, September 18, 2013 6:03 AM

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: 99038

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