G
Guest
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.
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.