Quick blog for now … I set up a new ASP.NET project, turn on NT auth, turn off anonymous access, write some ADO.NET code to connect to SQL Server via integrated security and viola! I get this lovely error: <P></P>
<FIELDSET><LEGEND>Arg!</LEGEND> <H2>Login failed for user ‘LANCELOT\ASPNET’. </H2>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'LANCELOT\ASPNET'.
Easy fix of course. Just need to add this line of code to my web.config file. One would think that after doing this repeatedly that Pavlov would learn.
</P> <FIELDSET><LEGEND>Impersonate me</LEGEND>
<identity impersonate=”true/> </FIELDSET>