FTS not working in certain machine

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

FTS not working in certain machine

Author

Topic

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-20 : 08:30:21

Hi,

we are implementing full text search in our database, but I have a problem while trying to do this in another machine.
In one server in was OK, and this command was running for some time:
EXEC sp_fulltext_table 'accounts', 'Start_change_tracking'
GO

But in another server where I want to do, it's being finished very fast the execution of the script for full text.

CAN YOU PLEASE SUGGEST WHERE THE PROBLEM CAN BE? IS THERE ADDITIONAL CONFIGURATION IN OPERATING SYSTEM OR SQL THAT I SHOULD ENABLE, OR ANY ADDITIONAL SERVIVICE I SHOULD START?

Thank you,
BaniSQL

sqlzagi
Starting Member

11 Posts

Posted - 2007-05-20 : 12:20:09

I will attach as well message on Event Viewer Log:

Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3024
Date: 5/20/2007
Time: 5:40:04 PM
User: N/A
Computer: FRZSRVNEW
Description:
The crawl for project <SQLServer SQL0000900008> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.

Thanks,
SqlZagi

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-20 : 17:25:15

Is mssearch service running under local system account? Is local system a member of sysadmin role?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources