Configuration of full-text search in files

Kentico CMS allows you to full-text search files uploaded into database. It uses standard Microsoft SQL Server Search Engine that allows you to index a wide variety of files. This chapter explains how you can configure your installation of Kentico CMS for search in files.

 

Prerequisites - Important!

 

If you're using Microsoft SQL Server 2000, you need to use Microsoft SQL Server 2000 Standard or Enterprise Edition - Full-text search is not supported with MSDE or in the Developer Edition.

 

If you're using Microsoft SQL Server 2005, you need to ensure that full-text search support is installed on the server. The full-text search is available for all editions of Microsoft SQL Server 2005, including Express Edition with Advanced Services.

 

Generally, full-text search support must be installed on your SQL Server and your web site must be configured for storing files in database (Site Manager -> Settings -> Files -> Store files in database must be checked).

 

Now follow one of the following guides:

 

Configuration of full-text search on Microsoft SQL Server 2000
Configuration of full-text search on Microsoft SQL Server 2005
Configuration of full-text search on Microsoft SQL Server 2005 Express Edition

 

 

 

 

Supported file types

 

The standard full-text search engine delivered with Microsoft SQL Server can search TXT, HTML, DOC, XLS and PPT files.

 

You can install a free driver from Adobe for searching in PDF files as described in chapter Searching PDF files.

 

If you want to search other types of documents, you need an appropriate IFilter library. IFilter libraries can be purchased from third-party vendors (you can find them using Google).