Re: SQL Profiler 2005 - IP Address?

It appears that the client's IP address displays when I select the 'Errors
and Warnings' in the Events Selection in Profiler 2005.

Thanks for the reply guys. I appreciate it.

Take care.

J


"Russell Stevens" <rustyprogrammer@xxxxxxxxxxxxx> wrote in message
news:udaAzItpGHA.3820@xxxxxxxxxxxxxxxxxxxxxxx
J,

As far as I know, you can't get that from the profiler. However, you can
run

netstat -n

from a command prompt, look for port 1433 (or whatever port you are using)
and get the IP number that way. If profiler is showing a bunch of
unsuccessful login attempts (typically trying to login under sa) then
those will have a time wait listed in the netstat output.

Russ Stevens




.

Relevant Pages

  • Re: Oh for a back door ...
    ... initiate a Windows install then do a repair install (which worked ... Prolific 2303 drivers for OSX and Windows. ... typical stages) but I can't see the port in the System Profiler? ... What's the device and what are you seeing in Profiler? ...
    (uk.comp.sys.mac)
  • Re: SQL Profiler 2005 - IP Address?
    ... you can't get that from the profiler. ... look for port 1433 ... unsuccessful login attempts then those ... will have a time wait listed in the netstat output. ...
    (microsoft.public.sqlserver.security)
  • Re: Profiler
    ... You could port your code to ... The only thing on the netcf are perf counters. ... > Anyone know of a profiler that works with compact framework? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)