Results 1 to 13 of 13

Thread: SQl Server Full Text Search

  1. #1
    Join Date
    Jul 2005
    Posts
    7

    SQl Server Full Text Search

    I have a server that has windows 2000 with Sql Server Enterprise edition sp3 installed and we are currently using the full text catalogs. I have another server that we have are trying to use the full text catalogs and it does not populate the catalog. I have check the microsoft search service to make sure it is logged in the same. I have gone through and recreated the catalogs twice and they will not populate. Can anyone give me any suggestion of things I can look for, Please ??

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Is startup account of microsoft search service a member of sql sysadmin on that server?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Is the database enabled for full text?.

    SELECT DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')

    Does it return 1?

    If it does, check if any table is enabled for fulltext.

    http://www.databasejournal.com/featu...le.php/1445201

  4. #4
    Join Date
    Jul 2005
    Posts
    7
    On both machines the Microsoft search service is logged in as local account.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Does builtin\administrators have sa rights on that server then?

  6. #6
    Join Date
    Jul 2005
    Posts
    7
    I ran the query SELECT DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
    and the result was one. I then went to the site and went through and read. I still have the problem.

  7. #7
    Join Date
    Jul 2005
    Posts
    7
    yes builtin\administrators has rights on that machine.

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Check windows application event log, there should have ms search related error messages. Post them if possible.

  9. #9
    Join Date
    Jul 2005
    Posts
    7
    I checked the event log and there were messages but this is what it says in the message :
    look at the file using the gatherer log query object (gthrlog.vbs, log viewer web page).

    Do you know how to look at those files ? where is the log viewer ?

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Not sure for that one. Try repopulate the catalog then check app event log for recent messages.

  11. #11
    Join Date
    Jul 2005
    Posts
    7
    These are the errors that I got in the following order :
    The crawl seed <MSSQL75://SQLServer/46e78a0c> in project <SQLServer SQL0000700005> cannot be accessed. Error: 800700e9 - No process is on the other end of the pipe. .

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

    The end of crawl for project <SQLServer SQL0000700005> has been detected. The Gatherer successfully processed 0 documents totaling 0K. It failed to filter 1 documents. 0 URLs could not be reached or were denied access.

    The catalog was not propagated, because no new files were detected for the project <SQLServer SQL0000700005>.

    have youever seen these messages before?

  12. #12
    Join Date
    Jul 2005
    Posts
    7
    I wnet out to google with that error code and someone else had posted this same error on the SQL forum. I looked at their entries and they also talekd about the built in administrator. I looked at the builtin administrator again and noticed it had access through membership. I changed it to grant access and then repopulated and it work. Thanks for going back and forth with me.

  13. #13
    Join Date
    Sep 2002
    Posts
    5,938
    Another way to fix the problem is that add 'nt authority\system' as sysadmin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •