Fulltext not being populated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BaniSQL - 20 May 2007 13:55 GMT

Hi,
It is strange that full text search for the same db and tables is working in
one server, but not in another one.
Error log for this:
Event Type:    Warning
Event Source:    Microsoft Search
Event Category:    Gatherer
Event ID:    3024
Date:        5/20/2007
Time:        2:28:23 PM
User:        N/A
Computer:    GJISRVNEW
Description:
The crawl for project <SQLServer SQL0000700006> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the crawl
again.
===============================================

Can this be due to Service Pack operating system on the machine- in the one
where is working is Enterprise Edition on Windows NT 5.2 (Build 3790: Service
Pack 2), in the one not working is Enterprise Edition on Windows NT 5.2
(Build 3790: Service Pack 2), DIFFERENCE IS IN SERVIE PACK.

Please help.

BR,
BaniSQL

Reply to this Message

Daniel Crichton - 21 May 2007 14:56 GMT

BaniSQL wrote on Sun, 20 May 2007 05:55:45 -0700:

> Hi,
> It is strange that full text search for the same db and tables is working
[quoted text clipped - 13 lines]
> again.
> ===============================================

I think the last time I saw this on my own server it was because I had
created a Catalog, but not actually added any tables to it. Check the
Catalogs and see if you've completed setting them up, or if maybe you've
added a table but not enabled it's FTI.

Dan

Reply to this Message

Hilary Cotter - 23 May 2007 14:07 GMT

Most frequently this is caused by changing the service account SQL Server
runs under via the services applet in Control Panel and by right clicking on
SQL Server in EM and selecting properties, security. In the Startup Service
Account, change it to System Account, restart SQL Server, and then change it
back to a local administrator account which is in the sysadmin role on your
SQL Server.

> Hi,
> It is strange that full text search for the same db and tables is working
[quoted text clipped - 26 lines]
> BR,
> BaniSQL

Reply to this Message