Azure Information Protection classified files can not be processed

Question

Hi All,

The full text search engine is failing to process azure information protection (AIP) classified files in filestream. Does MS SQL support full-text-indexing of classified files uploaded in filestream please? I can not perform any sort of text search on such files.

Thanks for your support.

Answer 1

Hi Cathy

I want to know if fdhost.exe can authenticate with Azure to crawl AIP protected / labeled files. Perhaps by installing a certificate in SQL server to authenticate with AIP. Is this something that can be achieved please?

Answer 2

Hi @SurfingSandy79 ,

Did you want to find the information about that File types supported by the Azure Information Protection (AIP)? Please refer to this MS document.

If I misunderstood, please let me know.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 3

Thanks.

For native Microsoft products, the extension does not change. Ex. .doc and .docx is in the list from the above query. A protected word or excel document has its contents encrypted. I believe I need a special Microsoft iFilter, capable of reading protected MS office documents. Or perhaps settings where fdhost.exe can use dedicated user credentials having permissions to read protected (classified) documents for indexing.

Answer 4

Does MS SQL support full-text-indexing of classified files uploaded in filestream please? I can not perform any sort of text search on such files.

Run this query

select *  
from sys.fulltext_document_types  

to see all supported document type for FTS. I don't know AIP file format, if it's e.g. of XML content, then you could change file extension or add a filter equal to XML to get it working.
See Configure and Manage Filters for Search