?
Solved

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

Posted on 2006-05-01
4
Medium Priority
?
491 Views
Last Modified: 2012-06-27
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
Comment
Question by:Eddy Belew
  • 2
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 16582693
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16582698
Also, you may want to make sure that you have the correct account set for the SQL Server search service.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question