Need to apply a Service Pack to the following SQL Express install:
Installed version : 12.0.2000.8 (2014) Express Edition
Not sure if I can apply the latest SQL 2014 Service Pack SP4 or stick to the latest Express Service Pack I have found SP3.
Are service packs for SQL 2014 different than the service packs for SQL 2014 Express?
Best Answer
There is no difference in service packs or cumulative updates between
SQL Server Express
edition and other editions such asdeveloper
,standard
orenterprise
.When looking at the latest build of
sql server 2014
, SP3 CU4 is the last one with build number:12.0.6329.1 (Latest build)
. I'm not sure whereSP4
is coming from?When looking at the applies to field from SP3 CU4:
You will find
SQL Server 2014 Express
Download
SP3 CU4
hereRemember that you would have to apply the service pack first, and then add the CU. A list of sql server (2014) build versions can be found here, here and an overview of all the recent updates here .
EDIT
Since Service packs are cumulative you can directly install
SP3
while skippingSP1
andSP2
and then installCU4
.The link provided is to download
sql server express
/local db
/express with tools
/express advanced edition
with theSP3
installed when you don't have express installed.You should download the regular SP3 patch, without express.
If you follow this link, you will see these two options:
Click on the one without express, SQL Server 2014 SP3
The ones with express are complete instances of sql server with the patch added.
Just to show you that I am not making this up, when scrolling down on the patch notes of SP3, go to the part: "Select the correct file to download and install"
Only install this one if you have no 64-bit version of SQL Server 2014 Express.
And for the correct file: (I think SP2 is a mistake, supposed to be SP3)
A patch for any Edition, express included. The Service pack you need,
SP3
is this one .Afterwards, download and install
CU4
forSP3
from here