没有在sql server中进行身份验证的Windows身份验证 [英] windows authentication without authenticating in sql server

问题描述

嗨


我在IIS7中使用我的凭据验证了我的应用程序，我不想在sql server中输入登录凭据，我希望我的应用程序执行Windows身份验证怎么做

解决方案

如果你想以登录用户的名义运行你的应用程序，你需要设置几件事：

- 正确设置应用程序池和其他iis和应用程序相关设置（请参阅此处： http://stackoverflow.com/questions/12966286/impersonate-domain-user-with-integrated-pipeline [ ^ ]）

- 正确配置范围内用户对所有必要资源的访问权限在所有受影响的服务器上

- 因为您将使用delegati在，您将需要一个功能齐全的Kerberos（在受影响的基础架构元素中不会回退到NTLM）

进一步阅读： http://www.adopenstatic.com/cs/blogs/ken/archive/2007/01/28/1282.aspx [ ^ ]

Hi
I have authenticated my application using my credentials in IIS7 and I don''t want to enter the login credentials in sql server and I want my application to perform windows authentication how to do it

解决方案

If you want to run you application in the name of the logged-in user you need to set up several things:
- set up your application pool and other iis and application related setting properly (see here: http://stackoverflow.com/questions/12966286/impersonate-domain-user-with-integrated-pipeline[^])
- configure properly the access rights to the users in scope to all necessary resources on all affected servers
- since you will use delegation, you will need a fully functional Kerberos (without fallback to NTLM in your affected infrastructure elements)
Further reading: http://www.adopenstatic.com/cs/blogs/ken/archive/2007/01/28/1282.aspx[^]

这篇关于没有在sql server中进行身份验证的Windows身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！