Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON

Buggyman

Hi,
I'm having problems with good old error... Login failed for user 'NT
Authority\Anony mous 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" ?>
<configuratio n>
<system.web>
<compilation defaultLanguage ="vb" debug="true" />
<customErrors mode="RemoteOnl y" />
<authenticati on mode="Forms" />
<authorizatio n>
<allow users="*" /> 
</authorization>
<identity impersonate="tr ue" />
<trace enabled="false" requestLimit="1 00" pageOutput="tru e"
traceMode="Sort ByTime" localOnly="true " />
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;Trusted_Conne ction=yes"
cookieless="fal se"
timeout="20"
/>
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
<appSettings>
<add
key="DBConnecti onString"
value="server=s ervername;datab ase=mydb;Integr ated 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.
:)

Nov 19 '05 #1

Subscribe Reply

3484

Juan T. Llibre

Use this short file I wrote :

identity.aspx
-----------------
<%@ Page Language="VB" %>
<%@ Import NameSpace = System.Security .Principal %>
<script runat="server">
Sub Page_Load()
Dim tmp As String = WindowsIdentity .GetCurrent.Nam e()
Label1.Text = tmp
End Sub
</script>
<html>
<head>
<title>WindowsI dentity.GetCurr ent.Name()</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" Runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
-------------

That will return the user the aspnet worker process is running under.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Buggyman" <Bu******@discu ssions.microsof t.com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

Hi,
I'm having problems with good old error... Login failed for user 'NT
Authority\Anony mous 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" ?>
<configuratio n>
<system.web>
<compilation defaultLanguage ="vb" debug="true" />
<customErrors mode="RemoteOnl y" />
<authenticati on mode="Forms" />
<authorizatio n>
<allow users="*" /> 
</authorization>
<identity impersonate="tr ue" />
<trace enabled="false" requestLimit="1 00" pageOutput="tru e"
traceMode="Sort ByTime" localOnly="true " />
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;Trusted_Conne ction=yes"
cookieless="fal se"
timeout="20"
/>
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
<appSettings>
<add
key="DBConnecti onString"
value="server=s ervername;datab ase=mydb;Integr ated 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.
:)

Nov 19 '05 #2

John

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" <Bu******@discu ssions.microsof t.com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

Hi,
I'm having problems with good old error... Login failed for user 'NT
Authority\Anony mous 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" ?>
<configuratio n>
<system.web>
<compilation defaultLanguage ="vb" debug="true" />
<customErrors mode="RemoteOnl y" />
<authenticati on mode="Forms" />
<authorizatio n>
<allow users="*" /> 
</authorization>
<identity impersonate="tr ue" />
<trace enabled="false" requestLimit="1 00" pageOutput="tru e"
traceMode="Sort ByTime" localOnly="true " />
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data
source=127.0.0. 1;Trusted_Conne ction=yes"
cookieless="fal se"
timeout="20"
/>
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
<appSettings>
<add
key="DBConnecti onString"
value="server=s ervername;datab ase=mydb;Integr ated 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.
:)

Nov 19 '05 #3

Juan T. Llibre

Second thoughts ( besides finding out the process account user ) :

re:

I've enabled anonymous access, setting it to the correct domain account,
Was that account NT Authority\Anony mous
.... or YourWebServerNa me\Anonymous ?

re: The specific domain account has been granted
the correct permissions in sql server
Was that account NT Authority\Anony mous
.... or YourWebServerNa me\Anonymous ?

re: <identity impersonate="tr ue" />
Since you *are* impersonating, it's the account that ASP.NET
is using as impersonation the one which needs permissions
everywhere.

That means the local user permissions, the SQL Server, etc.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Buggyman" <Bu******@discu ssions.microsof t.com> wrote in message
news:75******** *************** ***********@mic rosoft.com... Hi,
I'm having problems with good old error... Login failed for user 'NT
Authority\Anony mous 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" ?>
<configuratio n>
<system.web>
<compilation defaultLanguage ="vb" debug="true" />
<customErrors mode="RemoteOnl y" />
<authenticati on mode="Forms" />
<authorizatio n>
<allow users="*" /> 
</authorization>
<identity impersonate="tr ue" />
<trace enabled="false" requestLimit="1 00" pageOutput="tru e"
traceMode="Sort ByTime" localOnly="true " />
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;Trusted_Conne ction=yes"
cookieless="fal se"
timeout="20"
/>
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
<appSettings>
<add
key="DBConnecti onString"
value="server=s ervername;datab ase=mydb;Integr ated 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.
:)

Nov 19 '05 #4

Juan T. Llibre

Background info on this whole process is at :

http://msdn.microsoft.com/library/de...SecNetch12.asp

Make sure you read it...

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Juan T. Llibre" <no***********@ nowhere.com> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..

Second thoughts ( besides finding out the process account user ) :

re:
I've enabled anonymous access, setting it to the correct domain account,

Was that account NT Authority\Anony mous
... or YourWebServerNa me\Anonymous ?

re:
The specific domain account has been granted
the correct permissions in sql server

Was that account NT Authority\Anony mous
... or YourWebServerNa me\Anonymous ?

re:
<identity impersonate="tr ue" />

Since you *are* impersonating, it's the account that ASP.NET
is using as impersonation the one which needs permissions
everywhere.

That means the local user permissions, the SQL Server, etc.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======

"Buggyman" <Bu******@discu ssions.microsof t.com> wrote in message
news:75******** *************** ***********@mic rosoft.com...
Hi,
I'm having problems with good old error... Login failed for user 'NT
Authority\Anony mous 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" ?>
<configuratio n>
<system.web>
<compilation defaultLanguage ="vb" debug="true" />
<customErrors mode="RemoteOnl y" />
<authenticati on mode="Forms" />
<authorizatio n>
<allow users="*" /> 
</authorization>
<identity impersonate="tr ue" />
<trace enabled="false" requestLimit="1 00" pageOutput="tru e"
traceMode="Sort ByTime" localOnly="true " />
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;Trusted_Conne ction=yes"
cookieless="fal se"
timeout="20"
/>
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
<appSettings>
<add
key="DBConnecti onString"
value="server=s ervername;datab ase=mydb;Integr ated 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.
:)

Nov 19 '05 #5

Similar topics

9193

by: cerilocke | last post by:

I have an identical SQL database on two machines (my machine and a web server) that links to a database on a third server (S3). When I execute a stored procedure on my machine that accesses a database on S3, it always runs without a problem. However, when I run the same stored procedure on the webserver (via Query Analyzer on my machine, connected to the webserver), the stored procedure runs without a problem for about ten minutes, and...

Microsoft SQL Server

3456

NT Authority/ANONYMOUS LOGIN problem, only wierder

by: Mike Hutton | last post by:

Hi, I have tried to keep things simple. Not simple enough, obviously. I have a set of intranet ASP.NET pages which access a SQL back-end through the normal SQLConnection stuff. I want to use peoples' NT logons to user-stamp data changes made through the web-pages. So it seemed obvious to use Windows authentication to access SQL connections.

ASP.NET

3091

website connection to database time out problem : login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

by: Maellic | last post by:

Hi, The website I am working on is built with ASP.NET and connects to a SQL Server 2000 database. The web server and database are on the same machine. I have recently tried to modify the timeout of the website from 20 mn to 60 mn. I changed the timeout setting in IIS. Now the website itself doesn't time out, however after 20 mn, when I try to access a page that needs to connect to the database, I get the following error message

ASP.NET

4499

Preventing login as 'NT AUTHORITY\ANONYMOUS LOGON'

by: et | last post by:

I have an asp.net program that uses a connection string, using integrated security to connect to a sql database. It runs fine on one server, but the other server gives me the error that "Login failed for user "NT AUTHORITY/ANONYMOUS LOGON". Why would this be? There is no reason it should even be trying to login to using NT Authority/Anonymous login. The IIS Server is set to turn off anonymous logins, and use integrated security, and my...

ASP.NET

1823

database login failed

by: Chuck Bowling | last post by:

I'm having a problem that i really don't understand. I'm new to ASP.NET and to SQL Server (MSDE). I'm trying to get a VS walkthru in the C# to work. I think the problem is permissions but I'm not sure. I've tried adding the ZEUS\ASPNET user to the server using osql with the command "EXEC sp_grantlogin 'ZEUS\ASPNET'" but it had no apparent effect. Below is the error page that was generated when I tried to build and run the site: ...

ASP.NET

27989

beginner: "Login failed for user 'sa'."

by: Andrzej Magdziarz | last post by:

Hello, (sorry for my English...) Could you help me with a SQL Server 2005 problem? I had installed SQL Server 2005 and then I tried to setup some application using SQL Server. Unfortunatelly setup fails because the application cannot logon to SQL Server in SQL Server Authentication mode (user 'sa', password 'sa'). I checked Server Management Studio Express: I have sa/sa account (because I've prepared it), but although I can logon in...

Microsoft SQL Server

1164

Yet another login problem

by: SAL | last post by:

Hello, I'm a total asp.net newbie. I'm developing a web app and on my machine I login to a sql server just fine using NT Authentication via the connection string as: Integrated Security=True However, when I try to open the .aspx page from another machine I get the "Login in failed for user NT Authority\Anonymous Logon

ASP.NET

6269

by: gderosa | last post by:

I have been getting that dreaded error in my application: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have had my application in the test environment, impersonating it using a superuser domain account and setting proper permissions in both IIS and setting up the user in SQL Server. Now I moved my application to the production enviroment with the same exact settings as my test environment, and I am getting the "Login failed for...

ASP / Active Server Pages

12070

by: eruth | last post by:

There are loads of post on this, but nothing that seems to cover my exact problem ;) I have an ASP.Net 1.1 web application running on my local machine. I want to connect to an SQL 2005 server running on Windows 2003. If I use SQL authentication, all is fine and dandy. If I want to use windows authentication it gives the above error. My SQL server is set to allow both methods (first thing I checked) and is part of the domain (2nd...

ASP.NET

3960

by: cactuscrust | last post by:

I'm running IIS6 Windows2003, and as you'll see very quickly.. I'm pretty new to this stuff. Lately I've been getting bombarded with login attempts.... sometimes several in the same second, and it can last for hours. The event viewer shows the following information for the failed login: Logon Failure: Reason: Unknown user name or bad password User Name: Admin Domain: AXXXXX Logon Type: 8 ...

IIS / Internet Information Server

8231

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8614

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8471

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7153

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6107

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4075

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4167

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2603

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1474

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General