asked
Does searching pdf content in SQL Server 2014 work with IFilter?
I learned today that fulltext searches are not working for pdf's stored in the database. When I query sys.fulltext_document_types there is no entry for pdf's, however there are many entries for docx, xlxs, etc. I am running SQL Server 2014 Standard Edition on a Windows 2012 SP2 VM and do have Adobe 64 bit Ifilter 11.0 installed with the environment path updated. Does anyone have this configuration working for PDF searches?
[Here's one solution][1] provided earlier elsewhere and for a different version of SQL Server. Perhaps it might be of help? [1]:
http://stackoverflow.com/questions/272694/using-full-text-search-with-pdf-files-in-sql-server-2005
Excellent article. In my case a select * from sys.fulltext_document_types where document_type = '.pdf'. I installed Adbobe Ifilter 11.0, however I forgot to append the PATH system environment variable with: c:program Files\Adobe\Adobe PDF iFilter 11 for 64-bit platforms\bin\ I also failed to reboot the machine after changing the PATH system environment variable. After the operating system restart I did the following 2 commands to have SQL Server Read the operating system for the pdf interpreter: exec sp_fulltext_service 'load_os_resources', 1; exec sp_fulltext_service 'verify_signature', 0; Now that select * from sys.fulltext_document_types where document_type = '.pdf' returns a result I went in and rebuilt the full text indexes and everything is fine. In short whenever there new hardware involved building things from scratch can be a unique challenge. Thank you for the quick response.
18 People are following this question.
