Auditing users/logins - SQL Server Forums

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Auditing users/logins

Author

Topic

Jim Beam
Posting Yak Master

137 Posts

Posted - 2010-09-28 : 13:49:06

Hi all,

I need to do an audit of all users + logins for all users/services, including listing failed login attempts from inside and out.

Any ideas, people?

Cheers,

Jim

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-28 : 14:30:26

Failed login attempts will be in the SQL Server Error Log and Application Log of Event Viewer, assuming you've got the defaults in place.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jim Beam
Posting Yak Master

137 Posts

Posted - 2010-09-28 : 16:12:46

quote:
Originally posted by tkizer

Failed login attempts will be in the SQL Server Error Log and Application Log of Event Viewer, assuming you've got the defaults in place.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Cheers Tara, that had only occurred to me on the train back home, it was a damn long, hard day to say the least...

:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources