如何在 SQL Server 2012 FileTable 文件夹共享中启用权限? [英] How to enable permissions in SQL Server 2012 FileTable folder share?

问题描述

成功创建 FileTable 后，我尝试查看文件共享，但我的权限被拒绝.在 Management Studio 中，右键单击 FileTable，然后Explore FilteTable Directory"给我以下错误消息:

After successfully creating a FileTable, I tried viewing the fileshare but my permissions are denied. In Management Studio, right-clicking on FileTable then "Explore FilteTable Directory" gives me the following error message:

无法打开文件位置.未启用访问或您没有相同的权限.

The File location cannot be opened. Either access is not enabled or your do not have permissions for the same.

如果我尝试使用 \mycomputer\sqlexpress... 手动访问共享，我仍然无法访问.

If I try to manually reach the share using \mycomputer\sqlexpress..., I'm still denied access.

这是在我的本地机器上运行的 SQL Express.我正在从同一台机器访问这个共享.我错过了什么?

This is SQL Express running on my local machine. I'm accessing this share from the same machine. What am I missing?

推荐答案

对我来说，由于我的服务器是网络服务器，所以解决方案是:

For me, since my server is a networked server, the resolution was:

1. 进入SQL Server 配置管理器
2. 打开SQL Server 服务
3. 右键单击SQL Server (MSSQLSERVER) 并转到属性
4. 转到 FILESTREAM 选项卡并确保选中 允许远程客户端访问 FILESTEAM 数据

1. Step into SQL Server Configuration Manager
2. Open SQL Server Services
3. Right click on SQL Server (MSSQLSERVER) and go to properties
4. Go to the FILESTREAM tab and make sure Allow remote clients access to FILESTEAM data is checked

这篇关于如何在 SQL Server 2012 FileTable 文件夹共享中启用权限?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！