I have an ASP.NET 4.0/C# web application that I have deployed to a web server. However, pass through authentication is not working. I'm getting an exception in the app event log saying that, "The underlying provider failed on Open". When I check further, it is attempting to login to the SQL Server as the computer$ account.
What I want to have happen is the following.
User loads web application in browser.
Web browser passes windows authentication automatically to IIS 7.5.
IIS passes authentication information to SQL Server 2008 R2.
SQL Server checks that the user has permission and fulfills the request.
I have the following in my web.config.
<identity impersonate= ...
Go to the complete details ...