I tested this and it didnt log the IP address, if any one else has a suggestion other than a sniffer on the line it would be greatly appreciated.
~Mike
>Look at the C2 auditing features. I know it returns the origin of the request (client computer name) and the server process id (SPID) but I am not sure about the ip address.
>
>
>>Is there a way within SQL Server 2000 to log Ip addresses of unsuccesful login attempts? Or does Sql Server do this automatically any where?
>>
>>Thanks,
>>Mike