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 Apr 15 '15 at 13:58

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

| improve this answer | |
  • 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 – Rob Nicholson Dec 22 '16 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)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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