WCF模拟和SQL信任的连接？ [英] WCF Impersonation and SQL trusted connections?

问题描述

我们有一个是IIS7下托管的服务。对于SQL服务器的连接字符串设置为可信。为了使身份验证的发生，我需要的服务设置模拟并让客户端发起的模拟连接。

We have a service that is hosted under IIS7. The connection string for the SQL server is set to Trusted. In order for the authentication to happen I need to setup impersonation on the service and have the client initiate an impersonated connection.

有没有办法不具有模拟设定，并且仍然允许登录到SQL服务器的服务，通过受信任的连接？我们希望避免在客户端登录到服务。我们不知道他们将使用什么作为代理。我认为这更多的是与SQL服务器，而不是客户端的服务，SQL服务器的服务级别协议。

Is there a way to not have impersonation set and still allow the service to log into the SQL server, via the trusted connection? We want to avoid having the clients log into the service. We are not sure what they will be using as a proxy. I would think it is more of a service level agreement with the SQL server rather than the client to the service to the SQL server.

有什么想法？

感谢

推荐答案

如果您使用域帐户来运行应用程序池的服务正在运行下，您可以授予到SQL服务器帐户访问。在这种情况下，只有在运行该应用池的帐户将需要有权利。

If you use a domain account to run the Application Pool that the service is running under, you can grant that account access to the SQL server. In this case, only the account that is running the app pool will need to have rights.

这篇关于WCF模拟和SQL信任的连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！