At first, please download Adobe PDF iFilter 9 for 64-bit platforms and install it on your machine.

Please make sure that no other version of iFilter is installed on your machine.

After installing the PDF iFilter, it is recommended that you set your system PATH environment variable to the "bin" folder of the "iFilter" installation. For example, from the "Control Panel\System\Advanced\Environment Variables" tab, append to PATH "C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin\" and then restart the computer.

Check whether Adobe iFilter is registered with the server. In a new query window in the SQL Server Management Studio type and execute the following:

SELECT * from sys.fulltext_document_types

You should see a list of installed filters in the output window. Verify if you see entry for PDF (.pdf) with correct path set.

If you do not see an entry for ".pdf" then you need to execute the following two lines:

EXEC sp_fulltext_service 'load_os_resources', 1
EXEC sp_fulltext_service 'verify_signature', 0
GO

Restart the SQL Server. Re-run above query and verify that you see an entry for ".pdf".

Please follow the instructions on how to create full-text catalog for your database in our Developer's guide.

Run following query over your database to enable full-text search over your CMS_Attachment table:

EXEC sp_fulltext_table 'CMS_Attachment', 'activate'

Rebuild your full-text catalog. Right click on your full-text catalog and choose "Rebuild" option.

Now you can run following query over your database to test the behavior:

SELECT * FROM CMS_Attachment INNER JOIN CONTAINSTABLE(CMS_Attachment, AttachmentBinary, 'step') AS KEY_TBL ON CMS_Attachment.AttachmentID = KEY_TBL.[KEY]

"step" stands for expression which is included in some searched pdf file.



See also: Configuration of full-text search in files


Applies to: Kentico CMS 3.x, 4.x, 5.x