Canadian Computer Consulting

Full-Text Indexing Returns 0 Results

The Problem

SQL Server 2000 Full-Text Indexing (FTI or FTS) appears to work correctly, but nothing is actually in the index. Any search on the index returns 0 results and FullTextCatalogProperty shows NULL. Error 800700e9.

The Solution

There isn't actually NO error message. The following (or something similar) can be found in the Application Event Logs:

The crawl seed <MSSQL75://SQLServer/57a801ba> in project <SQLServer SQL0001700005> cannot be accessed. Error: 800700e9 - No process is on the other end of the pipe.

The crawl for project <SQLServer SQL0001700005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.

The solution, thanks to Schmidt, Phillip [PSchmidt@hdrinc.com]....
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=%238kez9jmBHA.2280%40tkmsftngp03&rnum=11&prev=/groups%3Fq%3D800700e9%26start%3D10%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D%25238kez9jmBHA.2280%2540tkmsftngp03%26rnum%3D11

In my quest for security, I had deleted the BUILTIN/Administrators account from the SQL Logins. Not so smart, cause that's why Full Text Indexing wouldn't work. You need to either add in the BUILTIN/Administrators group (which includes the local SYSTEM account) or add the SYSTEM account directly.

From SQL Query Analyzer, run the following:

sp_grantlogin 'NT AUTHORITY\SYSTEM'

sp_grantlogin 'BUILTIN\Administrators'

Then go into that account in Enterprise Manager and make sure that the account you added has System Administrator access, and Owner access to all the databases.

That's it. Problem solved. =)

Vancouver: 604-249-4486 Victoria: 250-412-1593 Edmonton: 780-701-7167
Email info@computerconsulting.ca