Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 currently have a MS SQL 2008 server installation with two instances "MSSQLSERVER" and "MSSQLSERVER2". When I run the installation CD/Setup and attempt to add new features, I get to the screen where you are supposed to select the instance you want to add features to, but it will ONLY allow me to select "MSSQLSERVER2". This is a problem as I wish to add full text search to "MSSQLSERVER", which I cannot select.

Any ideas why?

share|improve this question

The default instance is typically called "MSSQLSERVER" if you choose that during install. If you create other instances, then I would recommend a name like "INST2", "SQLEXPRESS1", or "SQLEXPRESS" instead of something that uses the substring "MSSQLSERVER". As a guess, I would say your probably running into an issue with the installer not recognizing some kind of reserved word that identifies the instance.

share|improve this answer
Yes, I have "MSSQLSERVER" which is the default instance. I also have "MSSQLSERVER2" which is another named instance. I fail to see any logical reason why these two names have anything to do with why I cannot install additional features on the default instance. – komlenic Jul 25 '11 at 19:44

Is full text search already installed on the default instance?

Have you tried to start the service in the SQL configuration manager?

share|improve this answer
No, full text search in not installed on the default instance. I have verified this with the query: SELECT SERVERPROPERTY('IsFullTextInstalled'), which returns 0. The only instance of the service in the configuration manager is for the MSSQLSERVER2 instance, so it is irrelevant. – komlenic Jul 25 '11 at 19:40

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.