| Event Id | 3018 |
| Source | Microsoft Search |
| Description | The end of crawl has been detected. The Gatherer successfully processed 0 documents totaling 0K. It failed to filter 1 documents. 0 URLs could not be reached or were denied access. Context: SQLServer Application, SQL0000XXXXXX Catalog |
| Event Information | When you start a full or incremental population, you may receive this event ( you can see more events from the same source along with this event) in the Microsoft Windows NT or Microsoft Windows 2000 Event Viewer application log and the population fails.
CAUSE : This behavior may occur if either of the following conditions is true: The BUILTIN\Administrators login was removed from SQL Server. -or- The Microsoft Search service is not running under the Local System account. RESOLUTION : To resolve the problem: Make sure that the BUILTIN\Administrators login exists in SQL Server. -and- Make sure that the Microsoft Search service is running under the Local System account. WORKAROUND In some environments, you may not want to allow Microsoft Windows NT or Windows 2000 system administrators to administer or access SQL Server. If that is the case and you want a full-text search, follow these steps: Grant the [NT Authority\System] user a logon to SQL Server. For example:EXEC sp_grantlogin [NT Authority\System] Add that account to the sysadmins role: EXEC sp_addsrvrolemember @loginame = [NT Authority\System] , @rolename = sysadmin |
| Reference Links | SQL Server Full-Text Search Does Not Populate Catalogs Installing SQL Server 2000 Service Pack 3 Rebuilds All Full-Text Catalogs |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.