April 15, 2015 | SQL Server

SQL Server 2014 Service Pack 1 was available – but there's a catch!

Stop me if you've heard this one before

Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services team blog

Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible workarounds and fixes. We have temporarily put the package download on hold and will provide an update with a solution. 

And you can see what can go wrong in the comments on this Data Platform blog post. If you're not using SSIS catalog / SSISDB, you should be fine, but if you haven't already downloaded the file, it's been removed – so you are going to have to wait for an updated package anyway. If you have already installed Service Pack 1 and SQL Server couldn't start, please see this post for a fix.

For now, it is build 12.0.4050, and contains all fixes up to and including Cumulative Update #5 (12.0.2456). In addition to staying away if you use SSISDB, DO NOT install SP1 if you are relying on fixes from Cumulative Update #6 or any COD updates that came out after CU #5. Relevant links:

5 comments on this post

    • Suren - April 16, 2015, 3:50 PM

      Looks like MS pulled out the download page. Cant download it anymore.

    • AaronBertrand - April 16, 2015, 4:26 PM

      @Suren that's correct, please see the update.

    • Ron Sexton - May 26, 2015, 9:00 PM

      I have CU 7 applied so it seems i should wait until a CU for SP1 comes along that catches it up to CU 7 ?

    • AaronBertrand - May 26, 2015, 9:06 PM

      Yes, Ron, you should wait for SP1 CU1.

    • Ron Sexton - May 26, 2015, 9:12 PM

      Thanks for the quick answer. Building for SAP and miscellaneous applications.

Comments are closed.