Full text indexing only works on one machine

Giganews Newsgroups
Subject: Full text indexing only works on one machine
Posted by:  Beak B. (Bea…@discussions.microsoft.com)
Date: Wed, 9 Aug 2006

We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000
sp4, also clustered.  Everything runs fine, except when we do a failover of
sql to the other node, full text indexing will not index.  The properties
come back with an item count of 1.  The only "errors" i can find are:

1-----------------------
Event Type:    Warning
Event Source:    Microsoft Search
Event Category:    Gatherer
Event ID:    3024
Date:        8/9/2006
Time:        9:54:55 AM
User:        N/A
Computer:    NODEB
Description:
The crawl for project <SQLServer SQL0001700006> could not be started,
because no crawl seeds could be accessed. Fix the errors and try the crawl
again.
-------------------------
2-----------------------
Event Type:    Warning
Event Source:    Microsoft Search
Event Category:    Gatherer
Event ID:    3036
Date:        8/9/2006
Time:        9:54:55 AM
User:        N/A
Computer:    NODEB
Description:
The crawl seed <MSSQL75://SQLServer/1fcdbceb> in project <SQLServer
SQL0001700006> cannot be accessed. Error: 8007007f - The specified procedure
could not be found.  .
---------------------------
Any help is appreciated.

Thanks in advance,
Beak.

Replies