English 中文(简体)
配置IIS以模拟用户进行SQL集成身份验证
原标题:Configure IIS to impersonate a user for SQL Integrated Authentication

我有一个关于如何使用Active Directory配置我的网站和IIS的问题。

我有一个网络应用程序,它将专门在我们公司的内部网络上运行。应用程序需要连接到的SQL数据库(通过active directory)只能由一个特定的AD用户DBAccess访问,但我使用Windows身份验证模式来验证我的用户。我会将身份模拟权限放入我的Web.Config中,但DB用户在Web服务器计算机上没有权限。

如何将IIS配置为使用DB Access用户连接到SQL Server,而不是在web服务器上本地运行?

提前谢谢,如果这有点基础的话,很抱歉。

最佳回答
  1. Set the application pool your application is using to run as the user you wish to connect to the DB as.
  2. Add Integrated Security=true; to your connection string.
问题回答

暂无回答




相关问题
connect Access via c#

i need to open a connection to a remote access db. in the local environment to the remote acess db is working great . when i run this application from production server (other server) it s fail ...

Joomla Cant Connect to DB

This sounds really easy to fix but I ve been working on it for awhile. Database Error: Unable to connect to the database:Could not connect to MySQL I had to make a local copy of Joomla for backup ...

"Unrecognized configuration section connectionStrings."

I had been working on a project in VS2005 that utilized a local connection to an Access DB. In the past week, I installed .NET framework 3.5 for use w/ a different project as well as VS6. I went ...

Connection Pooling and Multiple Connection Strings

An ASP.NET 3.5 application has two connection strings: Data Source=RedDB;Initial Catalog=Red;User Id=myuser;Password=pas;Max Pool Size=50;Min Pool Size=1 Data Source=BlueDB;Initial Catalog=Blue; ...

connection string in web config

I have a web application which i make on my local host and publish it on different servers. in the web config of this application i have connectionstrings property like: <connectionStrings> &...

热门标签