Tell me more ×
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. It's 100% free, no registration required.
up vote 2 down vote favorite

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

migrated from stackoverflow.com Jan 5 '12 at 18:59

2 Answers

up vote 1 down vote

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 sqlteam.com/article/sql-server-versions, 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

 
discard

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.