Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

installation screen

I need to add fulltext capabilities to an existing SQL Server 2008R2 instance but the one I need to upgrade is not actually available. The combobox shows only the one selected, as in the picture. It looks like it could be related to different versions of the two instances but I can't explain why. Any ideas?

share|improve this question

migrated from Jan 5 '12 at 18:59

This question came from our site for professional and enthusiast programmers.

Have you applied a non-public hotfix or patch? I can't find version 10.51.2500.0 listed anywhere. – Mark Storey-Smith Jan 5 '12 at 19:36

I agree with Mark's comment. Perhaps the default instance was installed with SQL 2012 (code name denali) beta or release candidate? If that's the case then you should be able to use that installer to try to add features but older versions of the binaries (like SQL 2008 R2) would not be able to.

share|improve this answer
Looking at this resource, I can confirm the fact that the default instance was updated with SP1 (windows update). The one I installed after from the dvd still has version R2 RTM. I now suppose this is sort of a bug that hides new versions when it comes to add new features because the dvd installer tries to match its own version number. Can someone confirm this? Any known workarounds? – g1ga Jan 6 '12 at 12:28
up vote 0 down vote accepted

I finally solved my problem by uninstalling SP2. Then, the instance version got back to the one matching the DVD and I was able to add FullText feature to the default existing one.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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