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

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.
I've experienced the same issue.
The SQL 2000 SP3a installer doesn't successfully complete on the Passive
nodes. Look on the Active node in C:\Windows at SQLSP*.Log, SQLSTP*.Log and
RemSetup.Log. In the RemSetup.Log, you should see that the process was not
completed successfully on all the nodes.
To fix the issue, open a command prompt and do execute the following:
C:\> cd "C:\Program Files\Common Files\System\MSSearch\Bin"
C:\Program Files\Common Files\System\MSSearch\Bin> regsvr32 tquery.dll
Try to 'Start a Full Population' on the table now to see if it resolved the
issue.
If this didn't solve your issue, you can do the following:
1. Reboot both nodes. (Don't skip this step!)
2. Fail over to the non working node.
3. Execute SP3a again on the non working node.
This should re-register all the necessary DLL's and resolve the issue.
Please post your results.
- David
|||It works fine now. The problem was with tquery.dll.
(I used sp3 though)
Thanks much.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!