SQL Server 2012全文检索FILESTREAMS与Windows加密文件系统（EFS） [英] SQL Server 2012 Full Text Search on FILESTREAMS with Windows Encrypting File System (EFS)
问题描述
这基本上是一个没有问题的，但是如果答案包括支持参考，如果答案是是，那么该如何解决。奇怪的是，我在MSDN或TechNet中找不到确切的答案，我的直觉和实验使我得到一个否的结论。
This is basically a yes/no question, but it is appreciated if the answer includes supporting references and a how-to if the answer is "yes". Strangely, I couldn't find a definitive answer in MSDN or TechNet, and my instincts and experiments lead me to a "no" conclusion.
是否可以使用Windows EFS与SQL Server 2012的FILESTREAMS和FileTables 和有关于这些FILESTREAMS的全文搜索工作？
Is it possible to use Windows EFS with SQL Server 2012's FILESTREAMS and FileTables and have Full Text Search work on those FILESTREAMS?
TIA
其他详细信息
我创建了一个Visual Studio SQL项目，在文件表上使用FILESTREAMS标记DB，全文搜索工作，所以我知道基准是好的。从那里我尝试了两件事。
I have a Visual Studio SQL Project created that stamps out DBs with FILESTREAMS on FileTables, with Full Text Search working, so I know the baseline is good. From there I tried 2 things.
-
浏览到物理 FileTable文件夹并使用EFS进行加密。这可能是错误的方法，因为我在创建数据库，日志和FILESTREAM之后添加加密。 SQL错误是消息233，级别20，状态0，行0
从服务器接收结果时发生传输级错误（提供者：共享内存提供程序，错误：0 - 没有进程
Browse to the physical FileTable folders and encrypt them with EFS. This is probably the wrong approach, since I'm adding encryption after creating the DB, Log and FILESTREAM. The SQL error is "Msg 233, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)" Disabling encryption on the physical folder puts things to rights.
首先加密物理目标文件夹，然后部署SQL项目（所以.MDF和.LDF也在磁盘上加密）。这似乎工作得更好，但是当我浏览UNC路径（\MyMachine\MSSQLSERVER\NewDb\Files）并在其中复制一个文件时，我从Windows中收到一个错误：目标文件夹访问被拒绝，您需要权限执行此操作。所以搜索可能正常，但是我无法将文件放在文件夹中。
Encrypt the physical target folders first, then deploy the SQL project (so the .MDF and .LDF are also encrypted on disk). This seems to work better, but when I browse the UNC path (\MyMachine\MSSQLSERVER\NewDb\Files) and copy a file there, I get an error from Windows: "Destination Folder Access Denied. You need permission to perform this action." So search might work, but I can't put files in the folder.
推荐答案
答案是是，您可以使用全文搜索加密FILESTREAMS。细节在评论中。
The answer is "yes" you can encrypt FILESTREAMS with Full Text Search. Details are in the comments.
这篇关于SQL Server 2012全文检索FILESTREAMS与Windows加密文件系统（EFS）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
