2

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?

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

2 Answers 2

Reset to default
3

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
1
  • 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, 2016 at 18:24
0

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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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