SQL Server Performance Forum – Threads Archive
auditing logins
I have enabled auditing all logins.BOL says that:
‘Log records for these events appear in the Windows application log, the SQL Server error log, or both, depending on how you configure logging for your SQL Server.’ I tried to find a way to ‘configure logging’ in Enterprise Manager. I failed.
So I asked Google. This is what I’ve found –http://tinyurl.com/6v7zw – and I agree with the author of this post; it is ridiculous. Has anybody found a way to ‘configure logging’?
Hi Marek, As far as I know you can either audit success or failure or both, and if auditing is on then the results go to both the eventlog AND the SQL error log Cheers
Twan
So there must be an error in BOL, I guess.
What kind of activity you want to audit? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by satya
What kind of activity you want to audit?
Failed logins.
We just run a trace called FailedLogins on all our instances. We then run a daily report to analyze it. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Even we too audit failed logins which was set on SQL Server and periodically run the trace for reporting purposes. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>