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

I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in the "Feature Selection" part for Full Text Search. Please don't tell me I hav to uninstall and reinstall?

share|improve this question
up vote 5 down vote accepted

No, unfortunately you'll have to install a new instance with the Advanced Services installation. In R2 you can only add features such as Full Text Search if you initially installed with the advanced services installation.

You could backup your database though and restore it to the new installation w/ Full Text Search. Or I think also detach/attach.

share|improve this answer
Yup that seems to have worked. Thanks – hofnarwillie Jul 12 '13 at 20:34
This was not working with the SP1 version of the Advanced Services package :( – Faiz Apr 27 '15 at 11:46

Its a two step process.

  1. In the installer select Maintenance/Edition Upgrade to upgrade your existing instance.
  2. Run the installer again and select Installation/...or add features to an existing installation/Add features to an existing instance.
share|improve this answer
Sorry, tried this, no luck – hofnarwillie Jul 12 '13 at 20:35
For SP1 version of the Advanced Services package, this did work, but for new instance (step 2). If you even go to existing instance option, you will see the features vanished and will requires restart of setup to get the features back for new instance.. – Faiz Apr 27 '15 at 12:02

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.