Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46 Full-Text Search is not

11 Nov 2006 1:23 AM

AngelEyes

I have SQL Server on my webserver. The version of SQL Server and My
Operating System, which I have got from the query "Select @@version" is

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)   May 3 2005
23:18:38   Copyright (c)
1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2
(Build 3790: Service Pack 1)

I want to do full text indexing on my Database. but when the option of
Full Text Search is disabled in Enterprise Manager. So, I have executed
the Query "EXEC sp_fulltext_database 'enable'". It gives me error
message. Error is

"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."

what should I do to enable full text indexing.

I have checked the following things.

1-   SELECT fulltextserviceproperty('IsFulltextInstalled')
         -- the rsult is 0

2-   From a command prompt run net start mssearch
           --the result is "The requested service has already been
started"

3-   Check if the following registry entry exists

>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\SQLServer

           -- It does exist.

4-   Is this a default instance or a named instance.
           -- It is a default instance

5-   check the following registry value exists ?

>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Tracking
>{E07FDDA7-5A21-11d2-9DAD-00C04F79D434

        -- It does not exist.

6-    Open Enterprise Manager, expand the server, expand Support
Services, can you see Full-Text Search there?

       -- No I do not.

please help me. Can I do full text search on MSDE ?

11 Nov 2006 1:07 PM

Hilary Cotter

You can't do full-text search on msde. You can on SQL 2005 express. You
might want to look at Quest's SQL Turbo which is supported on MSDE.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quote

"AngelEyes" <Musa.Tariq.R***@gmail.com> wrote in message
news:1163208227.648983.152500@e3g2000cwe.googlegroups.com...
>I have SQL Server on my webserver. The version of SQL Server and My
> Operating System, which I have got from the query "Select @@version" is
>
>
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)   May 3 2005
> 23:18:38   Copyright (c)
> 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2
> (Build 3790: Service Pack 1)
>
> I want to do full text indexing on my Database. but when the option of
> Full Text Search is disabled in Enterprise Manager. So, I have executed
> the Query "EXEC sp_fulltext_database 'enable'". It gives me error
> message. Error is
>
> "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."
>
> what should I do to enable full text indexing.
>
> I have checked the following things.
>
> 1-   SELECT fulltextserviceproperty('IsFulltextInstalled')
>         -- the rsult is 0
>
> 2-   From a command prompt run net start mssearch
>           --the result is "The requested service has already been
> started"
>
> 3-   Check if the following registry entry exists
>
>
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\SQLServer
>           -- It does exist.
>
> 4-   Is this a default instance or a named instance.
>           -- It is a default instance
>
> 5-   check the following registry value exists ?
>          >HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Tracking
>          >{E07FDDA7-5A21-11d2-9DAD-00C04F79D434
>        -- It does not exist.
>
> 6-    Open Enterprise Manager, expand the server, expand Support
> Services, can you see Full-Text Search there?
>
>       -- No I do not.
>
> please help me. Can I do full text search on MSDE ?
>