Knowledge Base

Permission Problems Crawling an ODBC DB

Article ID: 197620

Article Last Modified on 2/6/2000


APPLIES TO


This article was previously published under Q197620

SYMPTOMS

Crawling a SQL Server database fails with the following error in the Gatherer log:
<URL>, "PRTH_E_ACCESS_DENIED: -2147216891".

RESOLUTION

If the permissions are incorrect in the SiteServer/Knowledge directory, do the following:
  1. Go to the IIS snap-in.
  2. Bring up the Default Web Site.
  3. Make sure the Directory Security is set to Basic (Clear Text) and Windows NT Challenge and Response

    Note: Only set Windows NT Challenge and Response if this is a Windows NT (Intranet) instance.
Also, Make sure the SQL Server account set during the Catalog Build Wizard is valid and has the correct permissions.

NOTE: SQL or ODBC compliant crawls only exist in the Search Web Administration interface.

Go to:

http://<computer name>/siteserver/Admin/Knowledge/Search/Default.asp

where <computer name> is the Search server where the catalog will be created.

Keywords: kbprb kbpending KB197620