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.

 All Forums
 General SQL Server Forums
 Script Library
 How to enable Auditing for Logons in SQL Server

Author  Topic 

kennetu
Starting Member

33 Posts

Posted - 2010-01-22 : 07:11:59
Hi all,

Can someone help me with a documentation/checklist on how I can enable Auditing for Logons only in SQL Server?

Thanks for your usual support.

Regards,
Kenneth.

Kristen
Test

22859 Posts

Posted - 2010-01-22 : 08:05:12
There is a setting in the Server's Properties to log Failed and/or Successful logins to the SQL Log. Is that the auditing that you wanted?
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-01-22 : 08:19:35
Using that information , you can dig in deeper using Profile to gather activity

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2010-01-31 : 09:32:07
Well there is C2 auditing in SQL 2005 if you are looking to audit detailed activities but you have to watch out for logs it creates.
Go to Top of Page
   

- Advertisement -