SQLBlog.org

archives disclaimers
archives shortcuts bad habits
disclaimers
SQLBlog Home
bad habits
shortcuts
MERGE NOLOCK dates dynamic SQL
splitting SQL Server 2022 how to ask

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

Aaron Bertrand SQL Server / SQL Server 2014 5

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:

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

5 Responses

  1. Ron Sexton says:
    May 26, 2015 at 9:12 PM

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

  2. AaronBertrand says:
    May 26, 2015 at 9:06 PM

    Yes, Ron, you should wait for SP1 CU1.

  3. Ron Sexton says:
    May 26, 2015 at 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 ?

  4. AaronBertrand says:
    April 16, 2015 at 4:26 PM

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

  5. Suren says:
    April 16, 2015 at 3:50 PM

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