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

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