Unable to install sql server 2016 service pack 1 or 2

Cesc Llagostera Puigdevall 1 Reputation point
2021-03-01T09:22:02.43+00:00

Hi,

I have microsoft sql server 2016 developer edition installed on my computer (version 13.0.1745.2)

Windows update tells me (we use WSUS) that I need to install service pack 2

The installation fails (Error: 0x80070643)

I have tried the manual installation and I cannot select my sql server instance because it says Upgrade Status: Not applicable.

I have checked on https://sqlserverbuilds.blogspot.com/#sql2016x and I'm on a rather old version and it seems I should upgrade to service pack 2 and apply cumulative updates to be on the latest version

Anybody has experienced this same error?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,052 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Tom Phillips 17,716 Reputation points
    2021-03-01T12:47:39.16+00:00

    You are running a pre-release version of SQL 2016. You need to uninstall that version and reinstall a supported version before you can update.


  2. CathyJi-MSFT 21,106 Reputation points Microsoft Vendor
    2021-03-02T02:47:22.55+00:00

    Hi @Cesc Llagostera Puigdevall ,

    Suggest you using select @@version to check your SQL server version.

    Did your account has administrator permissions? Giving the user the accessability to these administrator permissions will allow the Windows Installer package to access parts of the system that would normally be out of bounds, such as C:\Program Files and C:\Windows. These are the places where the updates need to be installed to. Please refer to the blog How To Fix Error Code 0x80070643 to get more.

    If it is not work, please download SP2 and CU 16 from here. Then run the setup as administrator. Applying the SP2 for SQL server 2016, then apply the CU16 for SQL 2016 SP2.

    If the installation still failed, please share us the SQL server setup log for analysis.


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments No comments