We have SQL Server 2008 R2 SP3 installed. Need to add a feature to the installation, Business Intelligence Development Studio. The question is do features installed after the application of a service pack pick up that service pack? If not does the service pack have to be installed again?

  • Thanks to Aaron and Spörri. This would be for non-production servers. But still need to be correct.
    – PMSawyer
    Commented Apr 15, 2015 at 13:58

2 Answers 2


I would always err on the side of just installing the service pack again (it will know which components, if any, to update). Especially when adding client tools to a workstation - where this is not a major disruption. (And if you're adding BIDS to a production server, you should reconsider IMHO.)

  • Found this post after needing to do the same on SQL 2012. After installing the complete management tools, a dialog box popped up saying I need to install SP3 again Commented Dec 22, 2016 at 18:24

You will need to reinstall the service pack, it will only update the feature you installed from source. (and I second Aarons humble option)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.