Upgrading SQL 2104 SP2 to SP3 Issues

Ferrari, Marcelo 21 Reputation points
2021-11-16T14:58:55.487+00:00

Im having issues to upgrade a SQL 2014 SP2 instance to SP3. My local software installed this version but I need now to upgrade to SP3 for vulnerabilities issues. I cannot create a new instance, I need to upgrade the current installed.

Current version is: Microsoft SQL Server 2014 (SP2-GDR) (KB4505217) - 12.0.5223.6 (X64) May 26 2019 20:36:50 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
I have downloaded SQLEXPR_x64_ENU package.

149760-image.png

If I go to 2nd option which is Upgrading, this is what I receive
149740-image.png

If I go to first option, I choose Add features since I dont want a new installation

149749-image.png

but after clic Next, I cannot select anything
149835-image.png

and gives an error
149750-image.png

But If I choose Perform a new instance... I can select the Database Engine to be installed.
149829-image.png

But in the end it will ask for a new instance name and we dont need that. we need to upgrade the current one....
149845-image.png

hope someone can help on how to upgrade an existent SQL instance to SP3

thanks!

Marcelo

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Guoxiong 8,206 Reputation points
    2021-11-16T15:08:49.847+00:00

    If you want to install the service pack 3 on your existing sql server, you just need to download the exe file at Microsoft® SQL Server® 2014 Service Pack 3 (SP3). And then click the exe file to install it.


1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,771 Reputation points
    2021-11-16T15:24:54.937+00:00

    This is not the way to install service packs. Upgrade is for upgrading from major version to major version.

    To install Service Packs, you must download and install them. see: https://learn.microsoft.com/en-US/troubleshoot/sql/general/determine-version-edition-update-level


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.