Unanswered: Full-Text searching in SQL Server 2000
I am trying to create a full-text searching in SQL Server 2000, after trying different ways still failed.
I use a Windows login to start both MSSQLServer and SQLAgent services, created a full-text catalog in pubs database employee table in EM. Start full population but the status is always idle and never get populated.
My Windows login is a member of sysadmin role.
I extracted the gatherer log:
- The gatherer has started
- The initialization has completed
- Started Full crawl
- MSSAL75://SQLServer/75d7831f Add Error fetching URL, (800700e9 - No
process is on the other end of the pipe)
- Completed Full crawl
As I have been struggling in doing this for several days, if anyone has successfully doing a full-text search, please give me your experience and steps on how you did it successfully.