SQL文件流访问被拒绝 [英] SQL Filestream Access Denied

问题描述

我正在尝试实现BLOB Filestream，用于将文件上传和下载到SQL数据库。问题是，当我尝试对文件进行读写操作时，出现访问被拒绝错误。我使用它作为连接字符串。

I'm attempting to implement BLOB Filestream for uploading and downloading files to the SQL database. Problem is I get Access is Denied error when I attempt to wright to the file. I'm using this as the connection string.

< add name = connectionname connectionString = Data Source = lceinforme; Initial Catalog = DEVDB；持久性安全信息= True；用户ID =用户名；密码=密码；最大池大小= 5000 providerName = System.Data.SqlClient />

根据我的调查发现，我不能使用这种方法吗？我一直在使用Integrated Security进行阅读，但我认为我无法以这种方式进行连接。

From what I've looked up and understand is that I can't use this approach? I keep reading using Integrated Security, but I don't think I can connect that way. This has me stumped.

推荐答案

如果这是SQL Server 2008，那么我认为您必须依次使用受信任的连接为Filestream工作。您在连接字符串中指定了用户名和密码，这意味着您使用的是SQL登录名，而不是受信任的连接。

If this is SQL Server 2008, then I believe that you have to use a Trusted Connection in order for Filestream to work. You are specifying a Username and Password in your connection string, which means that you are using a SQL Login, and not a Trusted Connection.

如果这是该版本的更高版本SQL Server，然后...（对不起，中断了）
...这取决于SQL Server的设置。

If this is a later version of SQL Server, then ... (sorry got interrupted) ... it depends on the SQL Server settings.

是的，Windows / AD模拟应该可以（但是，SQL Server模拟可能不会）。

Yes, Windows/AD Impersonation should work (however, SQL Server Impersonation probably will not).

这篇关于SQL文件流访问被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！