Saturday, February 25, 2012

Recording failed logins

There is a requirement on two of the systems I am looking after to record any failed attempts to connect to SQL server. The SQL server version is 7. Is it possible to record and extract failed SQL server logins in SQL Server 7 and if so how is it done?
Thanks.In EM - right click your server and click on properties. Click on the security tab and select the appropriate audit level (in your case failure or all).|||Thank you.|||You are welcome and good luck.

No comments:

Post a Comment