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

From: Mike Lerch (mlerchNOSPAMTHANKS_at_nycap.rr.com)
Date: 06/12/03

  • Next message: Mike Lerch: "Limiting views on data in a table" 
    Date: Thu, 12 Jun 2003 16:40:54 -0400

    On Wed, 11 Jun 2003 15:29:54 +0530, "B Sethu Ramalingam"
    <itjobz@hotmail.com> wrote:

    >Hi All,
    >
    >I got the following error when try to connect with a SQL Server in Windows
    >2000 server Professional. I am accessing the database by using my PWS on my
    >system.I have the ASP in my system.
    >
    >Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
    >
    >[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
    >AUTHORITY\ANONYMOUS LOGON'.

    PWS must be using the NT AUTHORITY\ANONYMOUS LOGON account to get to
    the SQL Server. Is the SQL Server on your machine or remote? If on
    your machine you can create a SQL logon for NT AUTHORITY\ANONYMOUS
    LOGON perhaps. If it's remote you'll need to look at using integrated
    windows auth or something like that. PWS may not be able to do that.

    Lerch

  • Next message: Mike Lerch: "Limiting views on data in a table"

    Relevant Pages

    • Re: User ASPNET in SQL Server 2000
      ... and turn off anonymous access. ... a logon box will pop up if the user cannot ... >While I love integrated security in SQL Server, ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Capture SQL Server Connections
      ... LOGON TRIGGERS are only support in SQL Server 2005+. ... As long as the LOGON TRIGGER is running the connection is not yet made ... connecting so I can provide a custom authenication mechanism? ...
      (microsoft.public.sqlserver.server)
    • Re: User ASPNET in SQL Server 2000
      ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Run As Command
      ... Declare @VCHCOMMAND Char, ... if you are using BACKUP DATABASE command to backup the database then ... to use a seperate logon for the destination server. ... to SQL server bacause SQL Server cannot see that domain. ...
      (microsoft.public.sqlserver.security)
    • Re: User ASPNET in SQL Server 2000
      ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
      (microsoft.public.dotnet.framework.aspnet.security)