I'm having severe problems implementing Search/Full Text Indexing service
with SQL Server 2000 (SP3). Following a successful test using a development
server (Win Svr 2003) I've attempted to roll out an application that makes
use of Full Text indexing using a production server. The development server
and production server are identical in terms of OS, SQL server, other
applications etc and I've followed the same steps that were used to implemen
t
the Full Text Search on the developement server, on the production server.
Initially my problems started with not being able to create a Full Text
Indexiong catalogue. I've now rectified this (it was to do with the logon i
d
being used during the install of Search service - as part of the SQL server
install).
I now have a problem with actually populating the catalogue itself. The
Event log is issuing two errors when trying to populate the catalogue. The
first is:
"The crawl seed <MSSQL75://SQLServer/014935cb> in project <SQLServer
SQL0001900005> 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."
The second is:
"The crawl on project <SQLServer SQL0001900005> 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 b
e
cataloged. The URL restriction rules may have to be modified to include this
URL."
Any help with this would be greatly appreciated.
I've spent ages trawling the web to see if anybody else has had a similar
problem. The only items I found appear to point to Sharepoint services. As
far as I know SharePoint is not installed on the server in question (or is i
t
installed by default?) I feel a little bit out of my depth on this one!
Thanks
KevinKevin,
I think I know what the problem might be. This invovles modifying the
registry so I will issue the standard disclaimer of proceed with caution
when making any registry changes.
This problem is caused because the SQL Server 2000 Protocol Handler is
missing
from the Registry. The following key is the key that should be added to the
registry
and the problem should be fixed:
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Search\1.0\ProtocolHandlers]
"MSSQL75"="sqlfth75.sqlfth75.1"
Most likely you will see the following entries there, but not the one above.
"File"="MSSearch.FileHandler.1"
"Http"="MSSearch.HttpHandler.1"
"OleDb"="MSSearch.OleDbHandler.1"
Let me know if this works.
David Gerard
Microsoft SQL Server Support|||"David Gerard" wrote:
> Let me know if this works.
>
David,
Many Many Thanks.
Added the key, restarted Full Text Search service and hey presto.
Thanks again
Kevin
没有评论:
发表评论