December 10, 2003 at 1:41 pm
I was looking inot the AUDIT LEVEL option under the security tab and i had a couple of questions.
a> Would it affect the performance of the server if you turn on the AUDIT LEVEL to failure/success/all.
b> Is this a recommended way to audit logins and/or is there any other suggestion.
c>In SQL Server books online it says that the information is recorded to the Microsoft Windows application log, the SQL Server error log, or both, depending on how you configure logging for the instance of SQL Server.
Where can you configure logging for the server?
thanks
December 12, 2003 at 3:30 pm
Performance will be fine.
If all you want is to audit Logon failure and success then this is the best way.
If you want more then you need to start looking at profiler or a thrid party product.
I know of no way to log to one or the other location, just both or none.
Regards
Steve.
December 15, 2003 at 8:54 am
NEWTONS2 is right. Profiler can help with this . For more information how to make profiles record sucessful and unsuccessful logins see http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/prodtech/dbsql/sql2kaud.asp
Francis
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply