Full-Text Indexing option is greyed out in Tools Menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Agius - 28 Jul 2004 04:36 GMT

I am new to sql server. I have just installed Microsoft CRM which needs Sql Server. It tells me that I need to have Full-Text Indexing running on the database but it is greyed out. The Microsoft Indexing Service is running and I do not know what to do?
Any help will be appreciated.

Thanks

Brian

Reply to this Message

John Kane - 28 Jul 2004 05:06 GMT

Brian,
SQL Server (2000 ?) does not use the Indexing Service and in fact has it's
own 'full text search' service called "Microsoft Search" (mssearch.exe) that
uses the same basic technology as IS, but is specific to SQL Server tables.
Most likely the reasons the Full-Text Search option is grayed is: 1) the
"Microsoft Search" (mssearch.exe) service is not started and running. If it
is not, you should start this service and enable it to automatically start;
2) If the Full-text search menu items are grayed out, it may be due to the
type of account (local windows account) that you have your SQL Server 2000
(MSSQLServer) service running under. If so, then you should review the
following KB article: Q270671 (Q270671) "PRB: Full Text Search Menus Are Not
Enabled for Local Windows NT Accounts" at
http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671

If you have any related SQL FTS questions, please feel free to post them
here!
Regards,
John

> I am new to sql server. I have just installed Microsoft CRM which needs Sql Server. It tells me that I need to have Full-Text Indexing running on

the database but it is greyed out. The Microsoft Indexing Service is running
and I do not know what to do?

> Any help will be appreciated.
>
> Thanks
>
> Brian

Reply to this Message

Hilary Cotter - 28 Jul 2004 13:04 GMT

sometimes the menu items are greyed out but you can still manipulate SQL FTS
using the stored procedures.

Try something like this in the pubs database. If it fails you have another
problem. If it works, its Em acting up again:

if (select DATABASEPROPERTY(DB_NAME(), N'IsFullTextEnabled')) <> 1
exec sp_fulltext_database N'enable'

GO

if not exists (select * from dbo.sysfulltextcatalogs where name = N'test')
exec sp_fulltext_catalog N'test', N'create'

GO

exec sp_fulltext_table N'[dbo].[authors]', N'create', N'test',
N'UPKCL_auidind'
GO

exec sp_fulltext_column N'[dbo].[authors]', N'au_lname', N'add', 1033
GO

exec sp_fulltext_column N'[dbo].[authors]', N'au_fname', N'add', 1033
GO

exec sp_fulltext_column N'[dbo].[authors]', N'zip', N'add', 1033
GO

exec sp_fulltext_table N'[dbo].[authors]', N'activate'
GO

Signature

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

> Brian,
> SQL Server (2000 ?) does not use the Indexing Service and in fact has it's
[quoted text clipped - 24 lines]
> >
> > Brian

Reply to this Message