IT Systems Engineering

Installing updates on SQL Server 2008

So when I was installing SCCM 2012 I found  out that I need to install patches/updates on my SQL server.

To find out what version I was running I looked at this document.

How to determine which version and edition of SQL Server Database Engine is running

To determine the version of SQL Server, you can use any of the following methods:
Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
Method 2: Look at the first few lines of the Errorlog file for that instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. The entries may resemble the following:

I used method 2 and found out that my SQL server was:

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86)

For SCCM 2012 it needs Cumulative update #4. Strangely Microsoft’s official SQL server updates page shows that only CU3 is available. Anyway, googling CU4 for SQL 2008 quickly brings up this page.

Make sure you download the right version, by default it downloads the x64 version. My server OS was 32bit. The download is available for 32bit but you have to click on “Show additional information” to see the 32bit version.

Download and install is simple enough…. just click next-next and eventually it will ask for a server restart.

Now the version in the log is :

Microsoft SQL Server 2008 (SP3) - 10.0.5775.0 (Intel X86)

The above mentioned KB article says:

10.00.5775.00 SP3 CU #4 (2673383) Mar 19, 2012

So I guess we are good… CU4 is there now.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove that you are a human *