Problem Installing FTS

Hi there,
I have SQL Server SP3 (DEV Ed) Installed on my machine.
Select @.@.Version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I have popped in the SQL Server CD and ticked the FTS box and installed FTS.
After install i started the search service but FTS is still not enabled in
EM. I looked under Support Services in EM but FTS is not listed there.
Have I missed something? Do I need to re-install SP3 after I installed FTS
from the original SQL Server CD?
Cheers
Ash Moollan
www.moollan.net
what happens when you issue a select serverproperty('isfulltextinstalled')
If 1 is returned, SQL FTS is installed.
Hilary Cotter
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
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
FTS.
> After install i started the search service but FTS is still not enabled in
> EM. I looked under Support Services in EM but FTS is not listed there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Hi Hilary,
Thanks for prompt reply.
Statement returns 0 (zero).
However the SQL Server CD shows the full text search as ticked (installed).
Thanks
Ash Moollan
www.moollan.net
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
> what happens when you issue a select serverproperty('isfulltextinstalled')
> If 1 is returned, SQL FTS is installed.
> --
> Hilary Cotter
> 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
> "Ash Moollan" <ashraf*NOSPAM@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Windows
> FTS.
>
|||Ash,
Under what account do you have the SQL Server (MSSQLServer) service started
& running? The "system account" (LocalSystem), a DOMAIN\Account or a "Local
Windows account"? If the latter, you may want to review this KB article:
Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
Windows NT Accounts
http://support.microsoft.com/default...;en-us;q270671
Also, confirm that the FTS components are installed via the following sql
code (1 = installed)
SELECT FullTextServiceProperty('IsFulltextInstalled')
Finally, if you installed the FTS components AFTER you applied SP3, then yes
you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
components.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
> FTS. After install i started the search service but FTS is still not
> enabled in EM. I looked under Support Services in EM but FTS is not listed
> there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Ash,
You can remove (or un-tick) the checkmark via deleting or renaming this
registry key (remove <Instance_Name>, if this is not an named instance
installation of SQL Server 2000)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:unQVhB6zFHA.3780@.TK2MSFTNGP12.phx.gbl...
> Hi Hilary,
> Thanks for prompt reply.
> Statement returns 0 (zero).
> However the SQL Server CD shows the full text search as ticked
> (installed).
> Thanks
> Ash Moollan
> www.moollan.net
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
>
|||John,
Worked Great!
Thanks
Ash Moollan
www.moollan.net
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OgaJFF6zFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Ash,
> Under what account do you have the SQL Server (MSSQLServer) service
> started & running? The "system account" (LocalSystem), a DOMAIN\Account or
> a "Local Windows account"? If the latter, you may want to review this KB
> article:
> Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
> Windows NT Accounts
> http://support.microsoft.com/default...;en-us;q270671
> Also, confirm that the FTS components are installed via the following sql
> code (1 = installed)
> SELECT FullTextServiceProperty('IsFulltextInstalled')
> Finally, if you installed the FTS components AFTER you applied SP3, then
> yes you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
> components.
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Ash Moollan" <ashraf@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
>