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.
Upgrading SQL 2104 SP2 to SP3 Issues
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.
If I go to 2nd option which is Upgrading, this is what I receive
If I go to first option, I choose Add features since I dont want a new installation
but after clic Next, I cannot select anything
and gives an error
But If I choose Perform a new instance... I can select the Database Engine to be installed.
But in the end it will ask for a new instance name and we dont need that. we need to upgrade the current one....
hope someone can help on how to upgrade an existent SQL instance to SP3
thanks!
Marcelo
SQL Server | Other
1 additional answer
Sort by: Most helpful
-
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