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.