SQL Server setup failure - Setup encountered a failure while running job UpdateResult. Error code 0x876E0003

Created by Cheng Kah Poh, Modified on Thu, 12 Oct, 2023 at 3:01 PM by Cheng Kah Poh

While I try installing the SQL Server Express manually, it prompted a message “Setup encountered a failure while running job UpdateResult. Error code 0x876E0003.” After clicking OK, the installation process cannot be continued. Why?

Sql 0x876E00031.png


Possible Reason:

Installation updates issue.


Solution:

You may edit the DEFAULTSETUP.INI file to skip for the product updates in the installation.


1) Re-run the SQL Server installer and defined the SQL Server extracted setup file in the C drive.

Sql 0x876E00031 2.png


When the file done extracted, please stay on the SQL Server Installation Center and do not close the page.

Sql 0x876E00031 3.png


2) Go to C drive, find the folder that SQL Server extracted setup file, and click on X64 or x86 folder.

Sql 0x876E00031 4.png


Remark:
For SQL Server 2017 Express in C drive the folder name is SQLServer2017Media.
For SQL Server 2019 Express in C drive the folder name is SQL2019.

For SQL 2017 or SQL 2019, you need get into folder named ExpressAdv_ENU or Express_ENU, then get into the folder x64 or x86.


3) Then find a file named DEFAULTSETUP.INI and right click open with Notepad.

Sql 0x876E00031 5.png


4) Add another script, UpdateEnabled = False in new row as below, then go to File > Save.

Sql 0x876E00031 6.png


5) Now you can continue SQL Server Installation, and you should be able to install successfully.

Sql 0x876E00031 7.png


If inside folder x64 or x86 cannot find DEFAULTSETUP.INI, you may manually create it using Notepad and key in the script as below. Then save the file as DEFAULTSETUP.INI in folder x64 or x86.

Sql 0x876E00031 8.png



** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article