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

• Previous message: Robob: "Re: Constant Login/logoff events from machine account"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Sun, 14 Nov 2004 10:34:01 -0800

"Riane de Oliveira Torres Santos" wrote:

> I Still have problems.
>
> Now I have two win 2k server, one with IIS and one with Sql Server 2k.
>
> When I try to access from a client with 2k professional i have this error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'
>
> I´m using windows integration in both servers (IIS and SQL)
>
> Can anyone help me!?

I had this issue, try changing the ODBC config to use named pipes instead
of TCP/IP. Still not sure what breaks it and the SQl newsgroup had no fix.
One app with an Access front end would not talk named pipes and I had to move
it to another server.

Bummer!

Good luck,
Robert A. Ober

• Previous message: Robob: "Re: Constant Login/logoff events from machine account"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]