Kentico CMS allows you to search the content of files (document attachments) uploaded into the database. The attachment search uses the standard Microsoft SQL Server full-text search engine, which supports a wide variety of files. The search is available for all supported versions of SQL Server:
•SQL Server 2005
•SQL Server 2008
•SQL Server 2008 R2
•SQL Server 2012
•Full-text search support must be installed on your SQL Server. The full-text search is available for all supported editions of Microsoft SQL Server, including the Express Edition with Advanced Services.
•Your Kentico CMS website must be configured for storing files in the database (Site Manager -> Settings -> System -> Files -> Store files in database).
Use one of the following guides to configure your installation of Kentico CMS for search in files:
•Manually configuring full-text search on MSSQL Server
•Enabling full-text search on MSSQL Server (Script)
Supported file types
The standard full-text search engine delivered with Microsoft SQL Server can search TXT, HTML, DOC, XLS and PPT files.
•To search in PDF files, install a free driver from Adobe: Searching PDF files
•To search Microsoft Office Open XML documents, such as DOCX or XLSX, install a free IFilter pack: Searching Microsoft Office documents
If you want to search other types of documents, you need to install appropriate IFilter libraries. You can download or purchase IFilter libraries from third-party vendors.