Permission Problems Crawling an ODBC DB

ID: Q197620

The information in this article applies to:

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. 4. 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. 

Version           : WINNT:3.0
Platform          : winnt
Issue type        : kbprb
Solution Type     : kbpending

Last Reviewed: December 21, 1998