Post reply

Auditing all users and login accounts (esp. failed)

  • September 28, 2010 at 11:50 am

    #227405

    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

  • September 28, 2010 at 12:28 pm

    #1228596

    Ouch. Quite a project.

    You can get failed login audits through the Security tab of Event viewer.

    As far as getting a list of all logins for a database or a server, I recommend looking at sys.server_principals, sys.server_role_members, sys.server_permissions for the server level. Use sys.database_principals, sys.database_role_members, and sys.database_permissions for database level perms.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply