Microsoft search in Win 2003 + MS SQL 2000 cluster does not work.

Question

Microsoft search in Win 2003 + MS SQL 2000 cluster does not work.

Roust_m

SSCoach

Points: 17410
More actions
December 9, 2004 at 6:10 am

#87213

Hi!
I have Win Ent Server 2003 + MS SQL 2000 sp3 cluster.
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
My full text search does not populate catalogs on the named instance of the cluster, but works fine on the first node default instance. Moreover, when I move the named instance group to the first node I am able to populate a catalog, but if I move it back, the MS Search resource does not start and the whole group is forced to move back to the first node. These are the errors I get in the application log:
----------------------------------------------------------------------------------------------
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3036
Date:  08.12.2004
Time:  21:23:05
User:  N/A
Computer: CLUST-SQL2
Description:
The crawl seed <MSSQL75://SQLServer/43b6e2fd> in project <SQLServer$SECOND SQL0000700005> cannot be accessed. Error: 80070002 - The system cannot find the file specified. .
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3024
Date:  08.12.2004
Time:  21:22:23
User:  N/A
Computer: CLUST-SQL2
Description:
The crawl for project <SQLServer$SECOND SQL0000700005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
----------------------------------------------------------------------------------------------
I tried to use suggestions from KB317746, but it did not help.
Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

John Kane SSCrazy Points: 2810 More actions · Answer 1

The key error is "80070002 - The system cannot find the file specified" and one of these KB articles should be helpful to you:

Q304282 PRB: Full Text Resource Fails to Come Online on a Cluster with "Event ID 1069 :

SQL Cluster Resource 'Full Text' failed" Error Message

http://support.microsoft.com/default.aspx?scid=kb;en-us;304282&sd=tech

Q296890 "PRB: SQL Server 2000 Fails to Install on a Cluster If Service Startup Account Contains a Space"

http://support.microsoft.com/kb/q296890/

810056 INF: You Must Use Resource-Specific Registry Keys for SQL Server Cluster Resources

http://support.microsoft.com/kb/810056

812666 How to recover a failed full-text search resource on a clustered instance of SQL Server 2000

http://support.microsoft.com/default.aspx?kbid=812666

KB Article Q317746 is a good place to start when troubleshooting Full Text Search (FTS) issues, but it does not address cluster-specific issues as do the above KB articles.

Regards,

John T. Kane

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

John, will your homepage be online soon?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

John Kane SSCrazy Points: 2810 More actions · Answer 3

Very soon, Frank...

I've been somewhat pre-ocuppied with work-related activities that pay the bills... However, I do plan to have SQLFTS.com up and running as soon as I can as I now have a logo designed and I'm building up the content. Until then, I'm doing a bit of blogging at both SQLJunkies (technical) and MSN Spaces (personal). Once I do get it up & running would you be willing to link your site to it? As that is most helpful in getting higher PageRank values in the Google Search Engine as I've made a *small* study of search related topics over the past two years...

I've also been working on a book project on the subject of search (Internet, Intranet as well as in RDBMS, such as SQL Server) that will also include how to do pure T-SQL Full Text Search, i.e., without the MSSearch service. It will also cover how to extend and expand the use of the classic SQL/MSSearch FTS approch in both SQL Server 2000 and SQL Server 2005 (Yukon)...

Thanks,

John T. Kane

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Once I do get it up & running would you be willing to link your site to it?

Sure, if the content is as good as your answers here and on the newsgroups

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]