IIS 7.5将Windows凭据传递给SQL Server

本文介绍了IIS 7.5将Windows凭据传递给SQL Server的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个使用Windows身份验证来验证用户的Web应用程序.它还在其应用程序池中使用指定的用户.每当建立连接时，我都需要将应用程序池用户传递给数据库.它似乎没有将正确的ID传递给数据库以建立连接. 当我检查数据库服务器时，每次访问Web应用程序时都会看到以下错误. 用户"NT AUTHORITY \ ANONYMOUS LOGON"的登录失败.原因:基于令牌的服务器访问验证因基础结构错误而失败.检查以前的错误 以下是Web配置中的配置行.

I have a web application that uses windows authentication to validate users. It also uses a specified user in its application pool. I need to pass the application pool user to the database whenever it makes a connection. It doesn''t seem to be passing the proper id to the database to make the connection. When I check the database server I see the following error every time I hit the webapp. Login failed for user ''NT AUTHORITY\ANONYMOUS LOGON''. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors Below is the configuration line in the web config.

<add name="OLTPConnectionString" connectionString="Data Source=myservername.domain.local;Initial Catalog=DevDB;Integrated Security=True;" /> </connectionStrings>

问候 Farhan

Regards Farhan

推荐答案

你好，亲爱的， 我重新访问了网络服务的所有ROLES AND权限，并赋予了适当的权限(例如:dbOwner)，这给了我所有问题的答案.我能够连接到数据库并正确运行我的应用程序:) 谢谢大家的回答... 问候， Farhan Hello Dears, I revisited all the ROLES AND permissions for Network service and gave appropriate permissions (eg: dbOwner) and this gave me the answer to all my questions. I was able to connect to the database and run my application correctly :) Thanks All for your answers... Regards, Farhan