Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

You can find the account that the web app is running under by looking in the
'Identity' tab of the relevant 'Application Pool' within IIS 6. Try
allowing this access to your SQL server


"Buggyman" <Buggyman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:75311680-27E8-4BF4-AC8C-37E018E0E441@xxxxxxxxxxxxxxxx
> Hi,
> I'm having problems with good old error... Login failed for user 'NT
> Authority\Anonymous logon'.
>
> The default web page comes up fine, but when the user attempts to log in
> (which checks stored usernames in the database etc) then the error occurs.
>
> a) The Web server is on a seperate box to SQL Server.
> b) I'm using forms authentication.
> c) I've enabled anonymous access, setting it to the correct domain
> account,
> and am not allowing IIS to control the password.
> d) The specific domain account has been granted the correct permissions in
> sql server
>
> e) web.config file is basically as follows..
>
> <?xml version="1.0" encoding="utf-8" ?>
> <configuration>
> <system.web>
> <compilation defaultLanguage="vb" debug="true" />
> <customErrors mode="RemoteOnly" />
> <authentication mode="Forms" />
> <authorization>
> <allow users="*" /> <!-- Allow all users -->
> </authorization>
> <identity impersonate="true" />
> <trace enabled="false" requestLimit="100" pageOutput="true"
> traceMode="SortByTime" localOnly="true" />
> <sessionState
> mode="InProc"
> stateConnectionString="tcpip=127.0.0.1:42424"
> sqlConnectionString="data
> source=127.0.0.1;Trusted_Connection=yes"
> cookieless="false"
> timeout="20"
> />
> <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
> </system.web>
> <appSettings>
> <add
> key="DBConnectionString"
> value="server=servername;database=mydb;Integrated Security=SSPI"/>
> </appSettings>
> </configuration>
>
> It works fine from the web server.
>
> If anyone has any ideas, this would be most appreciated.
>
> Also (not sure if this will help me or not), how can I tell which user the
> aspnet worker process is running under?
>
> Many thanks.
>
> --
> Many thanks.
> :)


.

Relevant Pages

  • Re: Kerberos from XP to IIS hosting ASP.NET 2.0 Web Service help
    ... If your MS SQL Server is running under a custom /local/ account, ... not sure how Kerberos authentication is supposed to work. ... If SQL Server is running under a domain account, ... you are not authenticating to IIS as anonymous. ...
    (microsoft.public.inetserver.iis.security)
  • Windows Authentication with IIS on separate machines
    ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
    (microsoft.public.sqlserver.security)
  • Re: Trusted sql connection failure
    ... Is the SQL Server located on a different machine to the IIS webserver? ... you probably need to run ASP.NET under a domain account (or find some ... it appears that you are running ASP.NET under a local account (either ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: IUsr can not login
    ... I too am not sure what the IIS lockdown tool does (I am a SQL Server ... that had been assigned permission to login into SQL ... Amongst the NT account names will be the account/group that IIS ...
    (microsoft.public.sqlserver.security)
  • RE: SOME Users cannot access OWA others do, error HTTP 500
    ... I understand that some account access OWA ... IIS 6.0 compression corruption causes access violations ... compressed copy of the affected files on the SBS server: ...
    (microsoft.public.windows.server.sbs)