question

SurfingSandy79-0535 avatar image
0 Votes"
SurfingSandy79-0535 asked SurfingSandy79-0535 answered

Azure Information Protection classified files can not be processed

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.

sql-server-generalazure-information-protection
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SurfingSandy79-0535 avatar image
0 Votes"
SurfingSandy79-0535 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @SurfingSandy79-0535,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SurfingSandy79-0535 avatar image
0 Votes"
SurfingSandy79-0535 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.