Re: Where did the connections come from?



The login failure entries should have the IP address of the machine from
which the login was attempted. Look up that IP address on your domain and
see whose machine it is.

From the command prompt, this may help:
nbtstat -a the.ip.addr.ess

RLF
"bing" <bing@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72B6EC6E-DFBE-4A5D-ADA4-480FCCC95B05@xxxxxxxxxxxxxxxx
Hi,

We use SQL 2000 on Windows 2003. In Enterprise Manager, when I looked
through the SQL server logs, I found a lot login failures. But how can I
know where those login failure connections came from?

Thanks much in advance for any insight.

Bing




.