模拟文件流 [英] Impersonation Filestream

问题描述

我正在处理一个用文件流上传文档的项目。但是，文件流需要集成security = true，这对应于服务器上的Windows用户帐户。我对这个主题比较新... ...

由于用户只连接一个特定的sql帐户，我试图通过模拟解决它，但它只适用于本地帐户。

文件流教程我已经习惯了。

我有什么想法可以解决这个问题而没有让每个用户通过添加帐户来访问数据库？

编辑：

我可以在远程计算机上使用模拟（例如服务器吗？）

解决方案

您好兄弟，您使用的是sql server 2008吗？如果是这样，我认为以下两个线程可能对您有所帮助。

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/50ea9248-6edd-4f6a-bbc3-b1d119849341

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/e1756417-8820-42f8-b143-9d1df3aa79bc/

<另外，我建议你在Sql Server论坛上发帖以获得更好的支持。这是链接：

http：// social。 msdn.microsoft.com/Forums/en/category/sqlserver

希望这可以帮助你。

 

祝你有愉快的一天，

Hi,

Im currently working on a project to upload document with filestream. However filestream requires integrated security=true, which would correspond to a windows user account on the server. I am relatively new to this subject...

Since the users only connect with one specific sql account, i've tried to solve it with impersonation, but it work only with local accounts.
Filestream tutorial i've used as ground.

Any ideas how I can solve this WITHOUT giving every single user access to db by adding their accounts?

EDIT:

Can I use impersonate on a remote machine (e.g. server?)

解决方案

Hi bro, are you using sql server 2008? If so, I think the following two threads could be helpful to you.

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/50ea9248-6edd-4f6a-bbc3-b1d119849341

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/e1756417-8820-42f8-b143-9d1df3aa79bc/

And another, I recommend you to post in the Sql Server Forum for better support. Here is the link: http://social.msdn.microsoft.com/Forums/en/category/sqlserver

Hope this ca n help you.

 

Have a nice day,

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