Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

InvalidLogins.pl

By Chad Miller,

Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are renamed will retain the same SID, resulting in false positives.

Total article views: 237 | Views in the last 30 days: 4
 
Related Articles
FORUM

service account

Service account

FORUM

Creating accounts using SSIS ???

ADSI accounts

FORUM

Windows account

describe a windows account

FORUM

cancel account

how do you cancel account

FORUM

Proxy Account

How to create proxy account.

 
Contribute