I have an app that is being developed for our Intranet.
I have it so it will authenticate users that are members in an Active directory group.
But I am running into a problem when they try to connect to the SQL server.
Instead of connecting based on the Windows group, it is still connecting as NT AUTHORITY\ANONYMOUS .
How can i get the SQL connection to use the Windows group?
here is the Web.config:

<configuration>
  <system.web>
    <authentication mode= "Forms">
      <forms loginUrl="Webform2.aspx" name="adAuthCookie" timeout="60" path="/" >
      </forms>
    </authentication>
    <authorization>
    <allow users="*" />
      <deny users="?" />
    </authorization>
    <identity impersonate="true" />
  </system.web>
</configuration>


Here is my connection string
"workstation id=5WQ1K81;packet size=4096;integrated security=SSPI;data source=SERVERNAME;persist security info=False;initial catalog=livedb"

I setup a Windows group on the Database and in Active Directory.

The exception from SQL is
System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


Let me know if you need more details.

Hi,

Recently I also faced the same error, in my case Web site's "Host Header" is different from server's NetBIOS name.

Check the below URL that I found on microsoft server:
http://support.microsoft.com/kb/294382

Rohan Reddy

Change your data connection file

<udc:Authentication>
    <udc:UseExplicit CredentialType="NTLM">
                <udc:UserId>YOUR USER</udc:UserId>
                <udc:Password>YOUR PASSWORD</udc:Password>
            </udc:UseExplicit>
        </udc:Authentication>

and also don't forget to change your configuration file

<udc:ConnectionString>Provider=SQLOLEDB.1;Integrat ed Security=SSPI;persist security info=False;Trusted_Connection=Yes;Initial Catalog=YOUR DATABASE;Data Source=YOUR SERVER;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=YOUR USER ID;Use Encryption for Data=False;Tag with column collation when possible=False</udc:ConnectionString>


Being Optimisitc helps a lot