SQL Server Fulltext>: 80040154 - Class not registered -
01-20-2004
, 12:05 PM
I had the error below and could not find a solution. Called Microsoft
and obtained a solution. I am posting as an FYI to others than may
encounter this problem.
Event Type: Error
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 10006
Date: 1/15/2004
Time: 6:11:20 AM
User: N/A
Computer: SQLNODE2
Description:
An error occurred during the online operation for instance <SQL Server
Fulltext>: 80040154 - Class not registered
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Solution:
Bellow are the steps that we will have to take to get Full text search
right on the second node.
1. Make the cluster a single node cluster by removing the problem node
from the cluster so that the virtual server itself is available for
production
(Evict the Node, Remove Clustering Services from the bad node).
2. We might have to do the following to remove the Microsoft Search
service. Note that if the node is removed from the virtual server,
MSSEARCH will not be removed and hence the steps below need to be
followed
3. Removing Microsoft Search
Delete the folder C:\Program Files\Common Files\System\MSSearch
(Check for correct directory)
The following is the list of keys which will have to be deleted
before re-installing the MSSEARCH service :
a. HKLM->Software->Microsoft->Search
b. HKLM->System->CurrentControlSet->Services->MSFTPSVC
c. HKLM->System->CurrentControlSet->Services->MSSCNTRS
d. HKLM->System->CurrentControlSet->Services->MSSEARCH
e. HKLM->System->CurrentControlSet->Services->MSSGatherver
f. HKLM->System->CurrentControlSet->Services->MSSGTHRSVC
g. HKLM->System->CurrentControlSet->Services->MSSINDEX
4. Repair the Second node to fix any dll's that could be causing the
problem on the second node.
- This is done by running windows 2000 setup and selecting the
upgrade option.
5. Run setup to add the second node to the virtual SQL server. |