201 questions
You can install Service Pack3 directly. After installation of SP3, I would also recommend that yoy apply CU4 for SP3.
Towards upgrading SQL 2014 to 2019
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Radhai Krish
221
Reputation points
We are brim of making upgrading Windows Server as well as SQL Server.
Currently we are having SQL 2014 RTM, Enterprise Edition in Windows Server 2012 R2
We purchased license for SQL 2022, Enterprise Edition and on process of purchasing license for Windows 2022 DC.
Plan is to upgrade WS 2012 R2 to WS 2019 DC in the first place and then to upgrade the SQL 2014 to SQL 2019. Later towards 2022 in both.
But, as per it is mentioned in MS site, SQL 2014 should be of SP3 in order for it to be supported by WS 2019 DC.
Need assistance in how to proceed with upgrading SQL 2014 RTM to SQL 2014 SP3 within WS 2012 R2. Will direct upgrade to SP3 version would do? Or should we need to install all the CUs and SP1 & SP2 in order to reach SP3? Kindly help us. - Thank you!
SQL Server | SQL Server Transact-SQL
Windows for business | Windows Server | User experience | Other
20,213 questions
SQL Server | Other
14,501 questions
Accepted answer
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2024-06-08T15:43:43.1766667+00:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2024-06-08T21:55:00.2333333+00:00 I should add that once you have installed SQL 2019 make sure that you immediately apply the most recent Cumulative Update for SQL 2019.
Or go to SQL 2022 directly. And apply the most recent CU for SQL 2022.
Any particular reason you're aiming for SQL 2019?
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 13%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gowtham CP 6,030 Reputation points Volunteer Moderator2024-06-08T16:29:23.4966667+00:00 Hello Radhai Krish,
Thanks for reaching out in the Microsoft Q&A!
To upgrade SQL Server 2014 RTM to SP3, first, ensure you have recent backups of all your SQL Server databases.
Next, check for any compatibility issues with your applications using Microsoft's documentation.
Download the SP3 installer from the Microsoft Download Center, making sure to select the correct version for your system.
Run the installer, choose "Upgrade" during setup, follow the on-screen instructions, and accept the default selections.
The SP3 installer includes previous updates, so you don't need to worry about them separately.
After upgrading to SP3, you can migrate to newer versions like Windows Server 2019 and SQL Server 2019, or directly to SQL Server 2022 if your license permits.
If you need any assistance, feel free to reach out.
If the response helped, do "Accept Answer" and up-vote it to close the thread! Thanks.