up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

2 Answers

up vote 0 down vote

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.

link|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
feedback
up vote 0 down vote

Is full text search already installed on the default instance?

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

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

Your Answer

 
or
required, but never shown
discard

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