Latest Builds of SQL Server 2014 - SentryOne Team Blog

Latest Builds of SQL Server 2014

Microsoft has changed their servicing model slightly, in that for any particular branch, the CU download page only offers the most recent Cumulative Update. This is true no matter which KB article you came from. However, if you are looking for a specific Cumulative Update that doesn't happen to be the most recent one, you can download it from the Microsoft Update Catalog – just don't expect that to always have the latest.

Regardless of your branch or patch level, be sure to check out this CSS blog post and KB #2964518 : Recommended updates and configuration options for SQL Server 2012 / 2014, which is full of useful advice.

For help with acronyms used here or in the resources referenced, see Definitions of SQL Server release acronyms.

And of course, please always perform full regression testing before installing any SQL Server update in production. Kendra Little has a nice post about this.

Service Pack 2 Branch

Service Pack 2 (12.0.5000) was released on July 11, 2016, and includes 133 fixes and enhancements – including all of the fixes up to and including SP1 CU7. Those from SP1 CU8 should all be found in SP2 CU1, released August 25th. The official Knowledge Base article for SP2 is KB #3171021, and you can download the service pack here and the updated feature pack here.

Build Name Build # KB Article Date New fixes (public)
SP2 Cumulative Update #8 12.0.5557 KB #4037356 2017-10-17 15 (8)
SP2 Cumulative Update #7 12.0.5556 KB #4032541 2017-08-28 15 (8)
SP2 Cumulative Update #6 12.0.5553 KB #4019094 2017-08-08 29 (29)
SP2 Cumulative Update #5 12.0.5546 KB #4013098 2017-04-17 24 (21)
SP2 Cumulative Update #4 12.0.5540 KB #4010394 2017-02-21 30 (27)
SP2 Cumulative Update #3 12.0.5538 KB #3204388 2016-12-28 44 (39)
Security Bulletin MS16-136 (CU)
KB #3194718
12.0.5532 KB #3194718 2016-11-08 1 (1)
SP2 Cumulative Update #2 12.0.5522 KB #3188778 2016-10-18 18 (18)
SP2 Cumulative Update #1 12.0.5511 KB #3178925 2016-08-24 45 (36)
Security Bulletin CVE-2017-8516 (GDR) 12.0.5207 KB #4019093 2017-08-08 1 (1)
Security Bulletin MS16-136 (GDR)
KB #3194714
12.0.5203 KB #3194714 2016-11-08 1 (1)
Service Pack 2 12.0.5000 KB #3171021 2016-07-11 133 (53)

Some very interesting improvements in Service Pack 2, many of which were already included in SQL Server 2016. There were others, so this list should not be considered exhaustive, just OUR TOP 20:

Service Pack 1 Branch

Service Pack 2 has been released, and it really should be where your efforts are going, if it is possible (yes, I know some people have to stay on older service packs for a variety of reasons).

RTM Branch

If you're on RTM still (< 12.0.4000), there is an important security GDR/QFE that has been released through Security Bulletin MS15-058 and KB #3065718. This issue does not affect Service Pack 1. (And you should start planning to move to the SP2 branch now anyway.)

Comments ( 52 )

                                      • Jason Coombes says:

                                        Aaron, firstly thank you for maintaining these pages as they are invaluable to me (and I'm sure many others).

                                        I just wondered if it is worth including a note against SP1/CU9 and SP2/CU2 to call out the following KB:

                                        https://support.microsoft.com/en-us/help/3189033/fix-cannot-uninstall-service-packs-for-sql-server-2014-after-a-cumulative-update-is-installed

                                        Symptoms – Assume that you have installed a cumulative update on an instance of Microsoft SQL Server 2014 that has a service pack installed. When you uninstall the cumulative update and the service pack, none of them are uninstalled correctly. But you don't receive any error messages about this.

                                        This is fixed in SP1/CU9 and SP2/CU2 so worth highlighting I thought.

                                      • Totty says:

                                        > KB #3204388 says this is 12.0.5537, but the download is actually 12.0.5538.

                                        seems to be fixed now.

                                      • PeterS says:

                                        Does SQL Server 2014 SP1 CU 10 contain the security patch MS16-136 12.0.4487? Or do we need to apply both CU 10 and 12.0.4487 separately? We are on SP1 with no CU. MS16-136 GDR 12.0.4232 was applied and we were unable to connect to SQL Server. Once we rolled back that patch, everything is fine. We are now considering to apply CUs as per recommendations from MS. We are hoping to confirm that apply CU 10 will include the security patch as well.

                                      • Aaron Bertrand says:

                                        Yes, the fixes for MS16-136 should be in CU 10 (I am not sure why they neglect to put this information into the CU KB, but it has been common).

                                        That said, there is no harm, technically, in applying both patches.

                                      • François Schlaefli says:

                                        I cannot seem to be able to install SQL Server 2014 SP2 on a Windows Server 2012 machine with 2014 SP1 CU7 installed. When I need to select the instances to updated, all checkboxes are grayed out and I get the error message "There are no SQL Server instances or shared features that can be updated on this computer".

                                        Anybody confirms this ? Thanks

                                      • Aaron Bertrand says:

                                        Hmm, that did not happen to me, can you show what the instance selection screen looks like? There may be a hint in the table at the bottom that shows the existing instances and their versions.

                                      • François Schlaefli says:

                                        In fact, the problem was I was trying to install an English SP2 over a French SQL Server. No problem once I downloaded the correct file :)

                                      • Chris Wood says:

                                        You might want to change your count for SP1 CU7 as Kendra Little found this https://support.microsoft.com/en-us/kb/3166902 which references CU7 but isn't in the actual list of fixes.

                                      • Aaron Bertrand says:

                                        Thanks, you'll notice I maintain two counts, the first is the official number of fixes in the CU according to Microsoft, the second is the count of publicly visible fixes on the CU article itself (minus things like the @@VERSION/SERVERPROPERTY thing they keep including as a "fix" in every CU). I suspect the KB you're pointing out is counted in the former but not the latter.

                                      • Amish says:

                                        So my assumption was right, there was something wrong with SP1-CU6. I started from scratch and just installed RTM again. Now planning to SP1 and then cu6 after some days.

                                      • Amish says:

                                        Hi
                                        I installed SP1 CU6 and after then query on clustered column store started running forever.
                                        A query on table with 0.4 million rows takes 5 mins which was taking few seconds in RTM or SP1.
                                        Seems some serious issue with SP1 CU6 to handle clustered columnstore index.

                                      • Aaron Bertrand says:

                                        Can you let it finish and collect an actual plan, and compare that to an actual plan for the faster version (assuming you still have RTM or SP1 somewhere, which I hope so, because you are not performing these tests for the first time in production, right)? Did you look at wait stats? Where is the 5 minutes being spent?

                                      • Bill Fritz says:

                                        Hi All. Thanks for the Great Info!
                                        I applied SQL 2014 SP1 CU5 and it failed with
                                        "Script level upgrade for database 'master' failed because upgrade step 'SSIS_hotfix_install.sql' encountered error 3906, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion."
                                        This occurred on 2 Virtual servers in WSFC and AlwaysOn conf. Had to rebuild Master DB since could not restore due to now different version.
                                        Same CU5 worked fine on 2 other SQL 2014 SP1 CU3 servers. Any thoughts or has anyone else experienced this?
                                        Thanks,
                                        Bill

                                      • Aaron Bertrand says:

                                        Huh, that issue sounds awfully familiar to something that happened with SP1 (scroll up and see this and this). As I suggested above, I would contact support.

                                      • Bill Fritz says:

                                        Thanks Aaron, That looks EXACTLY like the issue I experienced. Wish I had that recovery process before I rebuilt the Master DB.
                                        I'll see if I can reproduce.
                                        Regards,
                                        Bill

                                      • Gregor says:

                                        Hey, i just successfully installed kb3130999 over a SQL 2014 SP1 Installation (12.0.4213.0) – without CU4.

                                        But https://support.microsoft.com/en-us/kb/3130999 describes:

                                        To apply this hotfix package, you must have SQL Server 2014 SP1 CU4 installed on your computer.

                                        So iam confused..

                                      • Aaron Bertrand says:

                                        That's a mistake, and it will get cleaned up. The hotfix is cumulative and does not require CU4 to already be installed.

                                      • Aaron Bertrand says:

                                        Hi Gregor, the wording in the KB article has been corrected:

                                        To apply this hotfix package, you must have SQL Server 2014 SP1 installed on your computer.
                                      • Jeff Humphreys says:

                                        12.0.4437 is available; it now includes COD Hotfix 3119148 and COD Hotfix 3097972.

                                      • Aaron Bertrand says:

                                        Thanks Jeff, I think I'm all caught up.

                                      • Cumulative Updates – SQL Server 2014 SP1 CU4 | Phoebix says:

                                        […] that two COD releases post-CU3 are not included in this update. The full info can be read on the SQL Sentry site, which covers the updates for both SP1 and RTM releases in SQL Server than I do in my […]

                                      • Albert says:

                                        After installing SQL Server 2014 SP1 CU3( I Noticed Microsoft updated the download link, there is a "latest" link, I have downloaded the latest setup file from there) on our test environment, nearly all instances' SQL Server agent failed to start, I tried to reboot the server but no help, finally I modified the the following Key:
                                        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\SQLServerAgent
                                        Modify the value data of the serverhost key to np:Virtualservername

                                        Ie:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
                                        Server\MSSQL.X\SQLServerAgent
                                        ServerHost
                                        Value: np:Virtualservername.

                                        This will force the SQLServer agent to connect with SQLserver using Named Pipes so
                                        delegation is not used.

                                        It looks like this bug:
                                        https://support.microsoft.com/en-us/kb/956378

                                        Anyone experience the same problem?

                                      • Patrick Clough says:

                                        Any update on being able to correctly download CU3? I tried today and get sent this link.

                                        http://hotfixv4.microsoft.com/SQL%20Server%202014/sp1/SQL_AS_OLEDB_64/12.0.4427.24/free/488007_ENU_x64_zip.exe

                                      • Aaron Bertrand says:

                                        Hi Patrick, I clicked on that link and it downloaded fine…

                                      • Tom S. says:

                                        At least you guys are able to download the hotfix – I've been getting 404 errors when trying to download this CU's bits from the link MS emails you when you request the hotfix (487890_intl_x64_zip.exe). And based on similar complaints from a few others on MS's blog entry for this CU, apparently I'm not the only one.

                                      • Aaron Bertrand says:

                                        Yes, I am getting a 404 now, but I was able to download it at the time. If I request a new hotfix download for x64 CU3, I get a different link than the previous e-mail I had received:

                                        http://hotfixv4.microsoft.com/SQL%20Server%202014/sp1/MS_SQL14_SP1_QFE_CU3_x64/12.0.4427.24/free/488103_intl_x64_zip.exe

                                      • Albert says:

                                        Hello Aaron,
                                        I installed SQL Server 2014 SP1 CU3, below is the output of "select @@version", but my version is different as the version number "12.0.4425" mentioned above, I did checked it yesterday on microsoft webiste, it is""12.0.4425.19", any ideas?

                                        Microsoft SQL Server 2014 (SP1-CU3) (KB3094221) – 12.0.4427.24 (X64)
                                        Oct 10 2015 17:18:26
                                        Copyright (c) Microsoft Corporation
                                        Developer Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)

                                      • Aaron Bertrand says:

                                        Yes, the original KB article (and in fact the build I originally downloaded) showed 4425. Now the source KB article says 4427, but others still say 4425 (e.g. this one and this one.

                                      • ErikEJ says:

                                        Should this: Recommendation: If you are using Analysis Services, or need to stripstream a deployment to multiple servers, apply SP2 Cumulative Update #2 instead.
                                        Not be instead: Recommendation: If you are using Analysis Services, or need to stripstream a deployment to multiple servers, apply SP1 Cumulative Update #2 instead.

                                      • Aaron Bertrand says:

                                        Yes, silly typo, thanks

                                      • Jeff says:

                                        Aaron,

                                        Just a follow-up. SP1 still fails an installation if I don't detach SSISDB first. I tried your steps, but they don't help. The T902 flag helps start sql, but that is it. Once the flag is removed sql won't start.

                                        It complains about not being able to find the 'ISSERVER' assembly. I tried to manually add the assembly, remove ssisdb, replace ssisdb, etc. all fail.

                                        It seems MSFT has another bug.

                                      • Aaron Bertrand says:

                                        Yeah I wouldn't expect this latest update to fix that – again, you should initiate a support ticket. If it is indeed a bug (and it sounds like it), the support ticket won't cost you anything, and you'll likely get a fix far sooner than CU #2.

                                      • Félix F. says:

                                        Many thanks for your fast answer!

                                      • Félix F. says:

                                        Hello,

                                        Is it advisable to install SP1 CU1 after having installed RTM CU8?

                                        I'm afraid that, for many of us, it's not clear which path, RTM o SP1, should be taken.

                                        Many thanks

                                      • Aaron Bertrand says:

                                        SP1 CU1 catches up to all of the fixes in RTM CU8, so yes, my recommendation would be to move to the SP1 branch as soon as your regression testing schedules allow (don't just do it blindly).

                                      • John B. says:

                                        Thanks Aaron. Late yesterday (7/8/2015), Microsoft confirmed my issue and your prediction above in an update message on the bottom of their blog post announcing this CU –> http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/06/22/cumulative-update-1-for-sql-server-2014-sp1.aspx .

                                      • John B. says:

                                        Hi Aaron,

                                        I just recently installed 2014 SP1 Cumulative Update #1 (12.0.4416) to my development workstation and one TEST server. Analysis Services (SSAS) continues to report itself as build 12.0.4100.1 (which is only SP1) and not build 12.0.4416.0. Given that there are quite a few SSAS fixes in this update, this doesn't seem to be right. When I look at the file information for CU #8 (https://support.microsoft.com/en-us/kb/3067836), I see a whole host of SSAS file updates that I do not see in CU 1 for Service Pack 1. From my outside-of-Microsoft perspective, it seems that the SSAS updates were not included in the SP1 branch update as advertised.

                                        Any insights or can anyone corroborate?

                                        Thanks in advance!

                                      • Aaron Bertrand says:

                                        Hi John, I'm not sure, did you check the setup logs? It sounds to me like the CU was applied only to the database engine and not to the SSAS instance. This has happened to me in the past too, where either the SSAS checkbox was unchecked or I inadvertently unchecked it without noticing.

                                      • John B. says:

                                        Hi Aaron,

                                        The setup logs show that SSAS was detected as an installed product, but there were definitely no actions applied to it (no "sql_as_Cpu64.log" file. I ran the cum. update installer several time to check that I had indeed selected SSAS in the feature tree. I am pretty convinced that the Microsoft SQL team left these out of the cumulative update. Guess I will need to open up a case with Premier Support.

                                      • Aaron Bertrand says:

                                        Yeah, sounds like support will be your best bet. If there is an issue, I am sure it will be corrected in CU #2 (which may come out of band, earlier than expected, due to a couple of other issues, such as slipstream not working with SP1).

                                      • Jeff says:

                                        Correct, it has happened with CU6, CU7 and CU8.
                                        We don't have anything special in our SSISDB configuration.
                                        If I get in that position again I will try your solution.

                                      • Jeff says:

                                        Just a word of caution with SQL 2014 CU6-8.
                                        I still get an error when the SSISDB is present. This results in the instance being corrupted. I had to reinstall SQL 2014, ensure the SSISDB is not attached and then do the updates. Then when updates are complete re-attach the ssisdb.

                                      • Aaron Bertrand says:

                                        Hi Jeff, did you see the notes I posted here? You shouldn't have had to reinstall SQL Server.

                                      • Jeff says:

                                        I didn't try your solution. My error was very different:

                                        2015-06-23 10:53:58.89 spid7s Assembly 'ISSERVER' was not found in the SQL catalog of database 'SSISDB'.
                                        2015-06-23 10:53:58.89 spid7s The failed batch of t-sql statements :

                                        CREATE FUNCTION [internal].[is_valid_name]
                                        (
                                        @object_name NVARCHAR(MAX)
                                        )
                                        RETURNS BIT
                                        AS
                                        EXTERNAL NAME ISSERVER.[Microsoft.SqlServer.IntegrationServices.Server.ServerApi].IsValidName

                                        2015-06-23 10:53:58.89 spid7s Error: 912, Severity: 21, State: 2.
                                        2015-06-23 10:53:58.89 spid7s Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 6528, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
                                        2015-06-23 10:53:58.89 spid7s Error: 3417, Severity: 21, State: 3.
                                        2015-06-23 10:53:58.89 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
                                        2015-06-23 10:53:58.89 spid7s SQL Server shutdown has been initiated

                                      • Aaron Bertrand says:

                                        Wow, that is a little different, but the warning about "recover the master database" can still be bypassed using the steps I outlined previously (a lot of folks have pressed the panic button, assuming they need to reinstall or completely restore master).

                                        And that happened with CU8? Nothing special about your SSIS installation except that the SSISDB catalog was in place?

                                      • Albert says:

                                        Thanks the updated,

                                        Is there a reason for CU8? since we can just follow one approach, e.g. upgrade to SP1 then install SP1 CU1 then all done.

                                      • Aaron Bertrand says:

                                        Hi Albert, there certainly is. Many people do not move to a service pack the moment it comes out, for a variety of reasons – regression testing, corporate policy, fear-mongering, what have you. Whatever the case may be, you can't just force everyone to move to service pack 1. Microsoft has historically always supported at least the current and previous service pack level, which means that those on the previous branch (in this case RTM) continue to receive security and performance updates, but they implicitly opt out of the feature changes that typically only ship with service packs.

                                      • Ray says:

                                        Incorrect Count of Cumulative Update #6
                                        no. of Cumulative fixes = 339 + 64 = 403 (not 390)
                                        (public) = 301 +55 = 356 (not 353)

                                      • Aaron Bertrand says:

                                        Thanks Ray, nice catch. My math was wrong, but not quite how you describe. The number of updates in CU #6 brings the total to the number of cumulative updates in CU #5 and the number of new updates in CU #6. The latter includes the three hotfixes released in between CU $5 and CU #6 – 403/356 would count those twice.

                                      • Cumulative Updates – SQL Server 2014 RTM CU3 | phoebix says:

                                        […] there is a security update I strongly urge you to consider installing on any servers. This post here sums it up […]

                                      • Mikhail says:

                                        Hi everyone,

                                        Just bought a SQL Server 2014 Developer Edition on Amazon and installing it now. I see there is a SP1, SP1 Cumulative Update #1, and SP1 Cumulative Update #2. I also see that there is Update 9 for SQL Server 2014 here: /team-posts/latest-builds-sql-server-2014/ . The prerequisite for Update 9 is SP1. What is the proper order to install this on my PC?

                                        Is it:

                                        SQL Server 2014 Dev Edition
                                        SP1
                                        SP1 CU1
                                        SP1 CU2

                                        or

                                        SQL Server 2014 Dev Edition
                                        SP1
                                        Update 9?

                                        Thanks guys

                                      • Aaron Bertrand says:

                                        Cumulative Update #9 is only for the RTM branch; you can't apply it to SP1. Where do you see that the prerequisite for update 9 is SP1?

                                        You should install: 2014, then SP1, then SP1 CU2. Cumulative updates are, as they're named, cumulative – so there is no need to apply SP1 CU1 before applying SP1 CU2.

                                      Leave A Comment

                                      Your email address will not be published.