Reinstall Full-Text Service SQL Server 2000

Hi all,
How can I re-install the full text service?
I can't create new catalog!
I can't delete existing catalogs!
I can't do anything involving the full text service, in Enterprise Manager
or via Query Analyzer.
Thanks in Advance,
Fabio
Fabio,
While removing and reinstalling the Full Text Search (FTS) components (see
below KB article 827449) may resolve this for you, it would also be helpful
to get any error number or error messages that you get when you attempt to
create or drop a FT Catalog via system stored procedures.
For example, what error do you get when you try to create the following FT
Catalog in the Pubs database?
use pubs
go
EXEC sp_fulltext_catalog 'PubInfo', 'create'
EXEC sp_fulltext_table 'pub_info', 'create', 'PubInfo', 'UPKCL_pubinfo'
EXEC sp_fulltext_column 'pub_info', 'pub_id', 'add'
EXEC sp_fulltext_column 'pub_info', 'pr_info', 'add'
EXEC sp_fulltext_table 'pub_info', 'activate'
go
For example, what error do you get when you try to drop the following FT
Catalog in the Pubs database?
use pubs
go
exec sp_fulltext_table 'pub_info','drop'
exec sp_fulltext_catalog 'PubInfo','drop'
go
If the above works successfully, for you on your problem server, then the
problem does not exist with FTS components and removal and reinstallation
may not be necessary. Could you also try the above procedures with your
FT-enable table and FT Catalog and post any errors that are returned. If the
errors that you receive for this "Catch-22" situation, then I can email you
a SQL script file to resolve this issue for you.
827449 How to manually reinstall the Microsoft Search service for an
instance of SQL 2000
http://support.microsoft.com/default...b;EN-US;827449
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Fabio" <fabio@.glb.com.br> wrote in message
news:#iqWcOfCFHA.328@.tk2msftngp13.phx.gbl...
> Hi all,
> How can I re-install the full text service?
> I can't create new catalog!
> I can't delete existing catalogs!
> I can't do anything involving the full text service, in Enterprise Manager
> or via Query Analyzer.
> Thanks in Advance,
> Fabio
>
|||Hi John,
I did all the steps from the article, but now I have the current problem:
when I go to delete an existing catalog or create a new one, the follow
message appears:
"the microsoft search service cannot be administered under the present user
account"
Do you know how can I solve this?
Thanks again
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eJFJwOgCFHA.328@.tk2msftngp13.phx.gbl...
> Fabio,
> While removing and reinstalling the Full Text Search (FTS) components (see
> below KB article 827449) may resolve this for you, it would also be
helpful
> to get any error number or error messages that you get when you attempt to
> create or drop a FT Catalog via system stored procedures.
> For example, what error do you get when you try to create the following FT
> Catalog in the Pubs database?
> use pubs
> go
> EXEC sp_fulltext_catalog 'PubInfo', 'create'
> EXEC sp_fulltext_table 'pub_info', 'create', 'PubInfo', 'UPKCL_pubinfo'
> EXEC sp_fulltext_column 'pub_info', 'pub_id', 'add'
> EXEC sp_fulltext_column 'pub_info', 'pr_info', 'add'
> EXEC sp_fulltext_table 'pub_info', 'activate'
> go
> For example, what error do you get when you try to drop the following FT
> Catalog in the Pubs database?
> use pubs
> go
> exec sp_fulltext_table 'pub_info','drop'
> exec sp_fulltext_catalog 'PubInfo','drop'
> go
> If the above works successfully, for you on your problem server, then the
> problem does not exist with FTS components and removal and reinstallation
> may not be necessary. Could you also try the above procedures with your
> FT-enable table and FT Catalog and post any errors that are returned. If
the
> errors that you receive for this "Catch-22" situation, then I can email
you[vbcol=seagreen]
> a SQL script file to resolve this issue for you.
> 827449 How to manually reinstall the Microsoft Search service for an
> instance of SQL 2000
> http://support.microsoft.com/default...b;EN-US;827449
>
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Fabio" <fabio@.glb.com.br> wrote in message
> news:#iqWcOfCFHA.328@.tk2msftngp13.phx.gbl...
Manager
>
|||Fabio,
Yes. The error message "the microsoft search service cannot be administered
under the present user account" is problematic and often caused by removing
or altering the SQL Server login BUILTIN\Administrators and it most likely
is the source of this problem for you. The MSSearch service needs this login
to log into SQL Server and you can either add back this login with the
original permissions (default master db, sysadmin privileges) or see KB
article:
263712 (Q263712) INF: How to Impede Windows NT Administrators from
Administering a Clustered SQL Server at:
http://support.microsoft.com/default...B;EN-US;263712
If you cannot add back the SQL Server login BUILTIN\Administrators login,
you can use the following SQL code as a substitute:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Fabio" <fabio@.glb.com.br> wrote in message
news:#nic2EiCFHA.3492@.TK2MSFTNGP12.phx.gbl...
> Hi John,
> I did all the steps from the article, but now I have the current problem:
> when I go to delete an existing catalog or create a new one, the follow
> message appears:
> "the microsoft search service cannot be administered under the present
user[vbcol=seagreen]
> account"
> Do you know how can I solve this?
> Thanks again
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:eJFJwOgCFHA.328@.tk2msftngp13.phx.gbl...
(see[vbcol=seagreen]
> helpful
to[vbcol=seagreen]
FT[vbcol=seagreen]
the[vbcol=seagreen]
reinstallation
> the
> you
> Manager
>