THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at since 2006, focusing on manageability, performance, and new features, and also blogs at and; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

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:

Published Wednesday, April 15, 2015 5:41 PM by AaronBertrand



Suren said:

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

April 16, 2015 8:50 AM

AaronBertrand said:

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

April 16, 2015 9:26 AM

Ron Sexton said:

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 ?

May 26, 2015 2:00 PM

AaronBertrand said:

Yes, Ron, you should wait for SP1 CU1.

May 26, 2015 2:06 PM

Ron Sexton said:

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

May 26, 2015 2:12 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog



Privacy Statement