[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 546
  • Last Modified:

sql server 2008 express edition: error on creating fulltext index

sql server 2008 express:

I get an error showing this:

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

I have the full text dameon service loaded..
Set to  Local Machine

Thanks
fordraiders

0
Fordraiders
Asked:
Fordraiders
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
FTS is not installed by default in Express Advanced. You should confirm that you actually selected to install it from the feature list. You can do this by running the maintenence mode from Add/Remove Programs.
0
 
wolfman007Commented:
Make sure you have downloaded and installed SQL Server 2008 Express with Advanced Services, if you have just installed SQL Server 2008 Express or SQL Server 2008 Express with Management Tools then you will not have Full-Text Search.

Full-Text is only available as part of SQL Server 2008 Express  with Advanced Services

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now