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.
Unable to install sql server 2016 service pack 1 or 2
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
2 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 21,136 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.