Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Full-Text search installed but not!

Author  Topic 

charlesinchina
Starting Member

1 Post

Posted - 2007-12-12 : 08:02:24
I'm having some problems with full text search not being available on My Small business server. I'm using MS SQL 2005. I'm sure I selected it to be installed but aparently it wasn't I've tried putting the install CD again and selecting it (everything on the install list turns up as a red X but the rest of it works fine) once i've ticked it I 'm told that it is already installed. if I run select fulltextserviceproperty('isfulltextinstalled') it comes back as 0. which i've been told means no installed and the MSFTESQL service doesn't seem to exist.

Anyone know how I can get this thing to install?

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2007-12-12 : 10:34:15
It might be installed, but not active. Check if you need to re-boot. Is the FTS service active?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-12 : 23:47:39
If MSFTESQL service doesn't exist, full text index is not installed.

Go to Top of Page
   

- Advertisement -