About Me - Who is DR DBA?

Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: sqlsurgeon@outlook.com

Monday, July 11, 2011

Show SQL authentication login information

The script provide will allow you to query the Active Directory (AD) for information related to users that are connecting to SQL server with Windows Authentication.

Copy and paste this code and execute

Here is a list of information at this displayed.

Bad Password Count
Bad Password Time
Days Until Expiration
Default Database
Default Language
History Length
Is Expired
Is Locked
Is Must Change
Lockout Time
Password Hash
Password Last Set Time
User name

Hope you find it useful.

Thanks,

Rudy

Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DeEdBMlV5ZllnMjA/edit?usp=sharing

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.