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
>