You can set it up using sp_configure or SQL Server properties. And you can capture the login failed, login success or both.
=>In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine with Object Explorer.
=>In Object Explorer, right-click the server name, and then click Properties.
=>On the Security page, under Login auditing, click the desired option and close the Server Properties page.
Note: you need to restart the server to apply the changes.
If you need something more then this you need to enable the C2 auditing, which is not recommended as it is resource intensive.
Let me know if you need more info.
Thanks -Virender M.
MS, MCTS, MCITP
From: SARADA DEVI <sv_39@...
Sent: Wednesday, 25 March, 2009 9:15:42 AM
Subject: MUGH-SQLCON i have coouple of problemw will you help me
I am trying to monitor following items:
4. Exixtence of users or ID in the server
5. Also, For example, we have two groups of DBA: Project DBA and Support DBA. I am a support DBA, and i have to grant access to project DBAs to production servers for one week and want to monitor if Project DBAs access is still in the production server or not.
I need a script to do this or something that helps me in achieving this task.
Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
[Non-text portions of this message have been removed]