When I powered on my SCCM lab, I noticed the SQL server wasn’t installed with latest cumulative update. Checking for the latest SQL cumulative update, I found that a new cumulative update was available for SQL server.
This post covers the steps to install latest cumulative update for SQL server. While the process of installing CU for SQL server is simple, I want to share the steps to do that via this post. I always recommend installing the latest SQL cumulative updates.
My lab has SCCM and SQL running on same VM. I always install SCCM and SQL on one VM because it provides the best performance. And moreover I like to keep my lab setup simple.
Determine the SQL Server Version
There are several methods to find the SQL server version and the easiest one is by running a SQL query. Launch the SQL Server management studio and run the query Select @@Version and execute it. That will give you information about the SQL Server version, service pack and cumulative update. I have also published a separate post on finding the SQL server version using different methods.
In my case I was running SQL Server 2014 SP3 with an old cumulative update. The latest CU available for SQL 2014 SP3 was KB4500181.
You might be running a different version of SQL server however you can download the latest CU version available for your SQL Server.
Installing SQL Cumulative Update on SCCM Server
First of all copy the KB4500181 update on to your SQL server. Right click the SQL cumulative update and click Install. Check the box I accept the license terms and click Next.
On the Select Features page, click Next.
In order for setup to complete, it checks if any applications and services are in use. In my case I got list of 3 processes that I had to deal with.
- Ssms.exe – This is a SQL management studio service and yes it was open while I was installing this update. Close the SQL Server management studio.
- WmiPrvSE.exe – I have covered about WmiPrvSE.exe in this post.
- Microsoft.Identity.Health.AadSync.MonitoringAgent.Startup.exe – If you find this process listed, you have to manually stop this process. Go to Services console and look for Azure AD Connect Health Sync Monitoring Service. Right click the service and stop it.
Click Refresh check and I don’t see any thing listed under Files in use. Click Next.
On the Ready to update page, click Next.
Wait for the update installation to complete. The KB4500181 installation is complete but it requires a system restart.
After restarting the server, login and open SQL server management studio. Right click the server and click New Query. Type the command select @@version and click Execute.
From the output you can determine the SQL server version, service pack, the cumulative update (KB4500181) that you just installed.