Is there a way to capture the "network user name" and the "host name" during a "login failed" alert
- by Jorge Rivera
I am a SQL Server 7 DBA and I would like to "improve" the default "Login failed" alert that brings SQL 7.
I need a way to know what "user" (network user name) was trying to connect to the server (not only the SQL user account) and I would like to know from where the user was trying to connect (the hostname).
Does someone know if this is possible? Using the SQL Profiler is not the best way since is a resource consuming task. Would be a way to setup an alert for doing this?
Thanks in advance.