• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

Full-Text Search Hit the Fan. Error: 80040d07

I am having a problem with Full Text Indexing.  I am running MS SQL 2000 on Server 2000 std.  When I tell the server to populate, it looks like it did, but no records/items are in the catalog.  I check the application log and here is what I see:

14:26  The crawl on project <SQLServer SQL0002900005> has started.

14:26  The crawl seed <MSSQL75://SQLServer/75d7831f> in project <SQLServer SQL0002900005> cannot be accessed. Error: 80040d07 - The specified URL is excluded and will not be cataloged. The URL restriction rules may have to be modified to include this URL.  .

14:26  The crawl on project <SQLServer SQL0002900005> cannot be started. All of the crawl seeds have been ignored because of host, extension, or other URL restrictions. Error: 80040d07 - The specified URL is excluded and will not be cataloged. The URL restriction rules may have to be modified to include this URL.  

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

14:26  The catalog was not propagated, because no new files were detected for the project <SQLServer SQL0002900005>.  

When I open up the srchadm snapin, I can see the start address I try to access is MSSQL75://SQLServer/75d7831f.  I know the search service works, and I can create a catalog that just searches a directory, and it works fine.  I do not have Sharepoint services installed.  I did not just install SP3 for SQL 2000.  When this problem first started it started with only a few tables, then every few days another one would do it.  I started a ticket with microsoft and they had me reinstall MS Search.  This only created more problems which I have fixed, but we are back to square on, except after reinstalling MS Search none of the tables will create full text catalogs.  Do any one know how I can test connections to this "URL" MSSQL75://SQLServer/75d7831f????  I know that it is a connection URL for the SQL database, but how can I see what the computer is really doing with my requests to this URL?  Anyone have any clue where to go from here?  I know I could reformat this server and start from square one, but this is a production server, and I am not looking forward to it.
0
Eddy Belew
Asked:
Eddy Belew
  • 2
1 Solution
 
Anthony PerkinsCommented:
Have you tried deleting the catalogs, rebuilding them and finally doing a full-population.

>>I know I could reformat this server and start from square one, but this is a production server, and I am not looking forward to it.<<
I have to say, that the only time that happened to us, we had to do precisely that.  Sorry to be the harbinger of bad news.
0
 
Anthony PerkinsCommented:
Also, you may want to make sure that you have the correct account set for the SQL Server search service.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now