Monitoring sql server login attempts including IP ?! please help

Hello
I am using sql server 7 and I am doing a trace on successfull sql logins and
also on unsuccessfull ones.
Everything works fine, but the only thing missing for my trace to be
accepted is the origin IP address ?
I have to have the trace to have the IP adresse from where the sql login is
attempted from.
I know that from the process info I have the Host wich is actually fine, so
I imagine that the trace could include it or I could have a query to lookup
some other systable....
I really have to have this report....
Thanks !Trace (profiler) does not include the IP , and i don't know how to get it
( other than going through the hostname)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"simo sentissi" <simo_sentissi@.skc.edu> wrote in message
news:OdKP$brCEHA.2616@.TK2MSFTNGP12.phx.gbl...
> Hello
> I am using sql server 7 and I am doing a trace on successfull sql logins
and
> also on unsuccessfull ones.
> Everything works fine, but the only thing missing for my trace to be
> accepted is the origin IP address ?
> I have to have the trace to have the IP adresse from where the sql login
is
> attempted from.
> I know that from the process info I have the Host wich is actually fine,
so
> I imagine that the trace could include it or I could have a query to
lookup
> some other systable....
> I really have to have this report....
> Thanks !
>|||Hello Wayne
I actually can't even have the hostname from the trace, I get it from the
process info.
is there any way of cross querying the trace with the process info ? huhhh
now that I think of it, it will be pretty hard sine the failed login will
not show up on the process info.
thanks !
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:%23jKVuMsCEHA.1544@.TK2MSFTNGP09.phx.gbl...
> Trace (profiler) does not include the IP , and i don't know how to get it
> ( other than going through the hostname)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "simo sentissi" <simo_sentissi@.skc.edu> wrote in message
> news:OdKP$brCEHA.2616@.TK2MSFTNGP12.phx.gbl...
> and
> is
> so
> lookup
>|||You can get the actual mac address for clients that are connected, but we
don't track the IP address for failed login attempts. I've requested this
feature for Yukon.
The only way you could capture this is to run a network trace on the server
while it's happening.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.