How to Apply the Latest Cumulative Update for SQL Server

This post demonstrates how to apply the latest CU( Cumulative Update ) on SQL server 2019.

1)Download the latest CU4( KB4548597 ) for SQL Server 2019 for Windows here.

2) Record the current SQL 2019 version.

3) Run “SQLServer2019-KB4548597-x64” as Administrator.

a) On “license Terms” page, choose “I accept the license terms and Privacy Statement”.

b) On “select features” page, select all the SQL server 2019 instances, shared features and all installed components.

c) On “Consent to install Microsoft R Open” page, click “Accept”.

d) On “Consent to install Python” page, click “Accept”.

e) On “Check Files in Use” page, stop all the services on the list, and click “refresh check” until no more processes listed.

f) On “Ready to update page” page, review the features list. click “Update” if everything is satisfied.

g) On “Update Process” page, monitor the patching process until it is complete.

Reboot the Windows Server if requested.

4) Verify the upgraded SQL 2019 version.

How to Install SQL Server 2019 on Windows Server 2019 VM of VirtualBox

After Windows server 2019 Oracle VirtualBox VM has been created as per How to Install Windows Server 2019 on Oracle VirtualBox,  now it is time to install SQL server 2019.

Subscribe to get access

Read more of this content when you subscribe today.

Step by Step Installing SQL Server 2014 on Windows Server 2012 Virtual Machine of VirtualBox

It is a great way to quickly build your own lab by using free Oracle VirtualBox, Windows evaluate Windows Server and SQL Server, etc.

Windows 2012 evolution has been installed onto VirtualBox in previous post. Now it is time to install SQL server 2014.

1. Attach ISO image ( SQLServer2014SP1-FullSlipstream-x64-ENU ) by :

Choose “Windows Server 2012” ->Setting->Storage->Adds optical drive->choose disk , then choose downloaded image “SQLServer2014SP1-FullSlipstream-x64-ENU”

Capture

2. Startup Windows 2012 virtual machine.

Capture

3. Clock just mounted CD Drive(D:) SQL 2014_x64_ENU.

Capture

4. Choose “Installation”->”New SQL Server stand-alone installation or add features to an existing installation”.

Capture

5. Select  “Evaluation” for “Specify a free edition:”

Click Next -> “I accept the license terms”.

Capture

6. Click Next, Choose “Use Microsoft Update to check for updates ( recommended ).

Capture

7. Check Install rules.

Capture

8. Choose “SQL Server Feature Installation” -> Click Next.

Capture

9. Choose all features, then click Next.

Capture

10. Feature Rules shows “Microsoft >NET Framework 3.5 Service Pack 1 is required”.

Capture

11. Go to “Server Manager”->”Add roles and features”->”Select features”->”Features”->check “NET Framework 3.5 features”.

Capture

12. Choose “Restart the destination server automatically if required”.

Capture

13. Click “Install” to start to install “NET FRamework 3.5 features”.

Capture
Capture

14. Click “Re-run”, and all checking passed.

Capture

15. Click Next.

Capture

16. Click Next.

Capture

17. Choose ‘Windows authentication mode”, and click “Add Current User” for ‘Specify SQL Server administrators”.

Capture

18. Select Server mode for SSAS.

Capture

19. Configure SSRS mode here. We can install and configure or install only for native mode. If we get any issue in the Install and configure installation mode than we can change this option to install only mode. We can navigate back and forth using the Next and Back button in this wizard.

Capture

20. “Add Current User” for “Specify Distributed Replay Controller service access permission”.

Capture

21. leave blank for “Controller Name”, and click Next.

Capture

22. Click “Install”.

Capture

23. Installation is successful.

Capture