Microsoft KB Archive/270671

= PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts =

Article ID: 270671

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q270671



SYMPTOMS
You cannot administer Full Text Search (FTS) from SQL Server Enterprise Manager (SEM) from a client computer when you are using a local user account to log on to the computer. This behavior occurs even if you connect to SQL Server with the &quot;sa&quot; logon. The FTS service is shown as not running in SEM on the client computer although the MSSEARCH service is running on the server.

Use query analyzer and full-text stored procedures to administer FTS.

If you try to start the FTS service under SEM from the client computer, you may receive the following error message:

An error 5 -(Access is denied) Occurred while performing this service operation on the MSSearch Service.



CAUSE
The FTS engine runs as a service named Microsoft Search on Microsoft Windows NT Server, and is listed as MSSEARCH under Control Panel (Services). A client computer that is using a local account cannot determine the state of such services as MSSEARCH on the server. Because the state of such services can't be determined by the client computer, you cannot start and stop them from the client computer. Also, because the state of the MSSEARCH service is unknown, the FTS menus are not enabled in SEM on the client computer.



WORKAROUND
Use stored procedures through Query Analyzer to administer FTS in this situation. By design, Query Analyzer does not check the state of the services before running any SQL statements or stored procedures. Any stored procedure is executed correctly if the FTS service is running on the server.

The following is a list of stored procedures that can be used to administer FTS:
 * sp_fulltext_database -- Initializes full-text indexing or removes all full-text catalogs from the current database.
 * sp_fulltext_catalog -- Creates and drops a full-text catalog.
 * sp_fulltext_table -- Marks or unmarks a table for full-text indexing.
 * sp_fulltext_column -- Adds columns to full-text indexes.



MORE INFORMATION
Please refer to SQL Server Books online for more documentation on how to use stored procedures to administer FTS.

Keywords: kbprb kbpending KB270671

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.