Re: Retrieve the IP Address from a Failed Login Attempt

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 12/27/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Fri, 27 Dec 2002 20:09:07 -0000

It is not possible to get the hostname or IP address with login auditing. 

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Josh" <None@nospam.com> wrote in message
news:064d01c2adc0$232c0a10$d7f82ecf@TK2MSFTNGXA14...
Hello,
Is there a way to configure SQL Server or even Profiler to
save or retrieve the IP Address of the system failing to
login to the server?
I receive this error in the Event Viewer/SQL Log:
18456:
Login failed for user 'sa'.
I have succeeded in logging this into profiler, but I have
found no way to resolve the IP Address.
Thanks,

Relevant Pages

  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)