NT AUTHORITY\ANONYMOUS LOGON

[EZEason]

ASP.net 2.0, IIS6 (web server), SQL Express(on data server) both running Win 2003. I'm developing a new company intranet. I have set up the following in the web.config file:

    <authentication mode="Windows" />
    <identity impersonate="true" />

connection:

<connectionStrings>
  <add name="DMnetConnectionString2" connectionString="Data Source=DMAPPS\SQLEXPRESS;Initial Catalog=DMnet;Integrated Security=SSPI; Connect Timeout = 90"
   providerName="System.Data.SqlClient" />
 </connectionStrings>

In the IIS setting I have disabled "Anonymous Access" and "Windows Integrated Authentication" is enabled.

I still get the following error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
If I run the app from my computer, it runs fine. I can see the user name in a text box I added to the default page.
What am I missing???

What doesn't kill you makes you stronger.

 

[BoulderBum]

If the database file is on a different computer than the web server, then you'll have to make sure the web server is authorized for delegation.

See here, the third question down:

http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/

You also want to make sure the site is properly configured in IIS for Windows authentication.