Latest Builds of SQL Server 2014

Updated August 26, 2016

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 #1 12.0.5511 KB #3178925 2016-08-24 45 (36)
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 ( 48 )

                                    • 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.