MS SQL Server FTS iFilter to search inside PDF, docx, pptx, and xlsx

To View the current supported document types that is available for full-text indexing operations. 

SELECT *

FROM sys.fulltext_document_types

To Support .docx, .pptx, .xlsx 

download and install the next file

https://www.microsoft.com/en-us/download/details.aspx?id=17062

To Support PDF Files

download and install Adobe PDF iFilter 11

http://ardownload.adobe.com/pub/adobe/acrobat/win/11.x/PDFFilter64Setup.msi

Then run the next command to load pdf extension

EXEC sp_fulltext_service 'load_os_resources', 1 

GO

EXEC sp_fulltext_service 'verify_signature', 0

GO

after windows reboot, the new iFilter will be ready and index the documents inside FileTable