从远程SQL Server访问文件流数据 [英] Access File stream data from remote SQL Server

问题描述

大家好，
我对.NET域&我在尝试使用 SqlTypes.SqlFileStream 类从 Microsoft SQL Server 2008 R2 数据库获取文件流数据时遇到了一个主要问题，原因仅在于数据库位于同一域中的远程PC中，而我的客户端位于同一域中的另一台PC中.错误看起来像(IE访问被拒绝或不受信任的域)，请提供示例项目，以便我可以解决问题.客户端和服务器也都在同一台PC上也没问题.
预先感谢，
Sounak

Hi All,
I''m pretty new to .NET domain & I''m having a major problem while I try to fetch file stream data from Microsoft SQL Server 2008 R2 database using a SqlTypes.SqlFileStream class just because of the reason that the database is in remote PC within a same domain and my client is in a different PC in the same domain.The error is look like (I.e Access denied or untrusted domain),please give a sample project so that I can solve the issue.I don''t have any problem while the client and server in same PC also.
Thanks in advance,
Sounak

推荐答案

访问被拒绝表示您已建立连接，但被拒绝.您需要在sql服务器中启用远程连接，还可能需要在防火墙中为其创建规则.

Access denied means you have made a connection, but it was refused. You need to enable remote connections in your sql server and also you may need to create a rule for it in your firewall.

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