I'm trying to figure out where failed logins are coming from. When I monitor my instance w/ profiler collecting failed logins, it does not collect hostname. Any suggestions?
The error msg does have an IP address though right? Open a command prompt and do a tracert <ip address> or a ping <ip address> - a to get the hostname.
No, the error message does not contain an IP address, just what user name was attempted. do you know how I could get an IP address on a failed SQL login?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply