logon failure with SQL Server 2K

From: John Cobb (jcobb@acxiom.com)
Date: 11/20/02 

From: "John Cobb" <jcobb@acxiom.com>
Date: Tue, 19 Nov 2002 20:10:23 -0600

>From front end app I need to determine whether logon failure occured because
logon Name was invalid or because the Password was invalid however SQL
Server 2000 gives the same message in both cases:

Server: Msg 18456, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'testuser'.

Is there anyway to discern bad logon name from bad password?

Thanks,
John

Relevant Pages

  • Cached Logon
    ... If IIS cached a logon just for one particular page, ... Authentication on SQL is set to SQL and Microsoft. ... It makes an ADO connection to SQL server using sa. ...
    (microsoft.public.sqlserver.connect)
  • Cached Logon
    ... If IIS cached a logon just for one particular page, ... Authentication on SQL is set to SQL and Microsoft. ... It makes an ADO connection to SQL server using sa. ...
    (microsoft.public.sqlserver.server)
  • Cached Logon
    ... If IIS cached a logon just for one particular page, ... Authentication on SQL is set to SQL and Microsoft. ... It makes an ADO connection to SQL server using sa. ...
    (microsoft.public.win2000.networking)
  • Cached Logon
    ... If IIS cached a logon just for one particular page, ... Authentication on SQL is set to SQL and Microsoft. ... It makes an ADO connection to SQL server using sa. ...
    (microsoft.public.inetserver.iis)
  • Cached Logon
    ... If IIS cached a logon just for one particular page, ... Authentication on SQL is set to SQL and Microsoft. ... It makes an ADO connection to SQL server using sa. ...
    (microsoft.public.sqlserver.security)
Loading