Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

According to this page, SQL Server 2008 Express Edition with Advanced Services includes Fulltext search:

http://www.microsoft.com/express/sql/download/

However, I downloaded it, ran it, and I see no sign of it. There is no fulltext service, and when I try to do anything to do with fulltext it says

Msg 7609, Level 17, State 5, Line 1 Full-Text Search is not installed, or a full-text component cannot be loaded.

When I run the re-installer to add features, I still don't see it. It claims I have everything installed.

Any ideas?

sql_server_2008

share|improve this question
    
this is exactly the situation i am experiencing. Seans answer is absolutely correct. It was driving me nuts –  Darko Z Feb 3 '10 at 2:07
add comment

2 Answers

up vote 1 down vote accepted

Judging by the screenshot, you downloaded the "Runtime with Management Tools" instead of "Runtime with Advanced Services" which includes Fulltext and Reporting Services. The x64 installer for SQL Server 2008 Express Edition with Advanced Services is here: http://download.microsoft.com/download/e/9/b/e9bcf5d7-2421-464f-94dc-0c694ba1b5a4/SQLEXPRADV%5Fx64%5FENU.exe

share|improve this answer
    
In my case, what actually happened is that I was running the correct installer, but during setup I had chosen an existing instance of SQL Server that was already running with the less-capable version. The advanced services installer won't let you add those features to an existing install. –  Tom Lianza Jul 29 '10 at 7:15
add comment

Unfortunately it looks we cannot add fulltext search service to basic Express edition. When you start new installation (not update of Express edition) there will be this option aviable.

I had to reinstall SQL Server to this extended edition.

share|improve this answer
add comment

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.