Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
discofish
Starting Member
5 Posts |
 Posted - 2004-08-11 : 18:34:10
|
| I am using SQL 6.5, I would like to monitor the failed login attempts by viewing the failed login/password. How can I capture this information? |
|
|
discofish
Starting Member
5 Posts |
Posted - 2004-08-11 : 18:52:04
|
| I've turned the password logging on. It apparently goes to the NT Service logs. Where do those reside on XP? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-11 : 18:54:52
|
| In the Application Log in Event Viewer in Admin Tools in Control Panel. Does 6.5 even run on XP? You would also see it in the SQL Server Error Logs.Tara |
|
|
|
discofish
Starting Member
5 Posts |
Posted - 2004-08-11 : 19:25:59
|
| It indeed is running on XP. I figured out the login-logging, now I just need to log the password too!2004/08/11 19:23:32.87 logon Login failed- User: WinInnObject |
|
|
|
|
|
|
Monitor Failed Login Attempts