使用Windows身份验证和特定的帐户连接到SQL Server [英] Connect to SQL Server using windows authentication and specific account
问题描述
我有一个ASP.Net应用程序,运行使用Windows身份验证。到SQL Server的连接通常是通过创建一个SQL Server的帐户,并使用该连接字符串中完成的。
I have an ASP.Net app, that runs using windows authentication. The connection to the SQL Server is usually done by creating a sql server account and using that in the connection string.
然而,在这种特定的非常严格的托管环境中,我们被要求使用特定的Windows / Active Directory帐户连接到SQL Server。
However, in this specific very restrictive hosting environment, we have been asked to use a specific WINDOWS/active directory account to connect to the SQL Server.
请注意这不是该网站的用户的Windows凭据,我们需要与连接到SQL服务器 - 这是一个特定的窗口/ AD帐户
Please note it is not the windows credentials of the user of the website, we need to connect to the SQL server with - it is one specific windows/AD account.
我如何配置我的连接字符串?
How do I configure that in my connection-string?
推荐答案
使用一个ConnectionString的是这样的:
Use a connectionstring like this:
Server=YourServer; Database=YourDatabase; Integrated Security=true;
您的节目就到,你需要连接的帐户下运行。您可以通过编辑程序池设置在IIS网站的身份。
Your program has to run under the account that you need to connect as. You can set the identity of your website in IIS by editing the AppPool.
这篇关于使用Windows身份验证和特定的帐户连接到SQL Server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!