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.

Thanks