Full-Text Search is not installed, or a full-text component cannot

Full-Text Search is not installed, or a full-text component cannot

Post by RGFsZ » Thu, 25 Aug 2005 06:01:02


I am unable to get Full Text Indexing to work with SQL Server 2000 Developers
Edition. When I execute this command:

EXEC sp_fulltext_database 'enable'

This is what I get:

(1 row(s) affected)

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded.

I attempted to install FTS again from the CD, but it indicates that it is
already installed.

Here is the version I am using:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright 1988-2003 Microsoft Corporation Developer Edition on Windows NT
5.1 (Build 2600: Service Pack 2)

When I run this at the command prompt:

net start mssearch

I get this:
The requested service has already been started.

More help is available by typing NET HELPMSG 2182

I not sure where to go from here.
 
 
 

Full-Text Search is not installed, or a full-text component cannot

Post by v-sgu » Thu, 25 Aug 2005 12:03:40

Hello,

The possible causes of this kind of issue may be as followings:


* Full-Text Search(FTS) is installed AFTER SQL Service Service Pack(SP).
This is the most common cause. Reapplying the SP fixes FTS.

* Microsoft Search service is not installed or started

* SQL server or Microsoft Search service is not started as a administrative
user


To narrow down the issue, I suggest that you perform the following steps:

1. Make sure SQL server and Microsoft Search service are started as the
same domain\administrative user account
2. Install the latest SQL SP4 or reinstall SP3.

Microsoft SQL Server 2000 Service Pack 4
< http://www.yqcomputer.com/
-99A9-B7F0213F8BC5&displaylang=en#filelist>


I hope the information is helpful.


Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 
 
 

Full-Text Search is not installed, or a full-text component cannot

Post by John Kan » Mon, 17 Oct 2005 04:27:19

Dale,
Sorry for the late reply on this thread, but this type of question is best
answered in the fulltext newsgroup.
The key bit of info here is the SQL Server edition "SQL Server 2000
Developers Edition" as FTS is not installed by default as it is with Std.
Edition and above. You can "re-install" the FTS components via removing or
renaming the following product tracking registry key (remove :
"<Instance_Name>\" if this is not a named instance):

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}

Then you will be able to re-install the FTS / MSSearch components. You may
also want to review the procedures in KB article 827449 "How to manually
reinstall the Microsoft Search service for an instance of SQL 2000" at
http://www.yqcomputer.com/ ;EN-US;827449


Sophie, the advise that you've provided is wrong and will cause known
problems, i.e.. high CPU utilization (there is a KB article on this).
Specifically, the Microsoft Search service MUST be started and running under
the "System account" (LocalSystem), while the MSSQLServer service can be
started and running under either LocalSystem or DOMAIN\Account (but NOT the
DOMAIN\Administrators account!). All this I've learned from years of
experience with SQL FTS since 1998 SQL 7.0 Beta3 while at MSFT...

Regards,
John
--
SQL Full Text Search Blog
http://www.yqcomputer.com/