Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON

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: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote development advice
    ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ... I want to be able to access the pages that my friend has done remotely ... Then whichever web site he has configured as the default site on IIS should appear, assuming the web server was configured correctly. ...
    (microsoft.public.dotnet.general)
  • Re: SQL2K WIN2K3 CONNECTION SECURITY
    ... My own benchmarking indicates that TCP/IP is faster than named pipes. ... the benchmark stats as the starting point... ... Perfmon and SQL Server Profiler along with SQL Server Query Analyser. ... encrypted on the web server. ...
    (microsoft.public.security)
  • Re: connect to sql server on web server
    ... I want to connect to SQL Server on the web server from my workstation ... My workstation is in the same room as the web server but our network ... as a general networking question. ...
    (microsoft.public.sqlserver.connect)
  • Re: sometimes endless loop, sometimes not
    ... I couldn't afford a hosting with SQL server:) ... and ensure that row level locking isn't being disabled. ... >> to use it on my web server and moved to SQL Server when I started getting ...
    (microsoft.public.data.ado)
Loading