Symptoms:

– The search function of your Microsoft SQL 2000 (MSSQL2000) powered web site does not return any results.

– In Microsoft SQL server 2000 – MSSQL2000, full text population of a catalog runs fast and completes almost immediately. Even after the full-text catalog population, the Item Count of the full-text catalog may still be 1.

– In event viewer, you find the following event:

Event Source: Microsoft Search
Description: The crawl seed in project cannot be accessed.
Error: 8007007f – The specified procedure could not be found.

Event Source: Microsoft Search
Description: The crawl for project could not be started, ecause no crawl seeds could be accessed. Fix the errors nd try the crawl again.

Potential Cause 1 (Ref: KB 277549)
SQL Server adds itself as an Administrator to the MicrosoftSearch service (MSSearch). When the service logon account for the MSSQLServer service is changed through Control Panel, the service logon account no longer has administrative privileges over the MSSearch service, thus causing the error messages shown in the “Symptoms” section.

Workaround 1 (Ref: KB 277549)
Steps to Reproduce Behavior
1. Open the SQL Server Enterprise Manager. From the Action menu point to Properties, and then click Security.
2. Change the Startup service account to System Account.
3. Stop and then restart the MSSQLServer service.
4. Change the Startup service account back to the domain account you want. (Make sure that you perform this task through the SQL Server Enterprise Manager and not Control Panel.)
5. Stop and then restart both the MSSQLServer and MSSearch services. SQL Server should now have administrative control over the Microsoft Search

After implementing the workaround in KB 277549, the problem was not resolved. Upon further investigation, KB 817301 indicated that certain DLLs pertaining to full-text search may need to be re-registered. The following workaround was implemented:

WORKAROUND 2 (REF: KB 817301)
To work around this problem, re-register the following Microsoft Search (MSSearch) DLL files on all the nodes of the Failover cluster:
Query.dll
Tquery.dll

To re-register the DLLs, follow these steps:
1. Open a command prompt.
2. Run the following command: regsvr32 Full path of MSSearch DLL file
Note: by default, the MSSearch DLL files exist in the C:\Program Files\Common Files\System\MSSearch\Bin folder.
After you re-register the DLL files, perform the full-text catalog population. If the full-text catalog is still not populated, you must re-register all the DLL files that are in the MSSearch DLL files folder.

This workaround was also unable to fix the problem.

Workaround 3:

Re-install the Full-Text portion of the SQL Server Service Pack 3a update.

1- Stop the MSSQLserver service.

2- Insert the MSSQL SP3a install CD-Rom in the CD-Rom drive.

3- Run the following from the command line prompt: <CD-Drive>:\SQLSERVER2000SP3a\x86\FullText\MSSearch\Search\SearchStp.exe
/s /a:SQLServer

After the re-installation the problem was fixed. Full text population started working again, as well as the search function.

Advertisements