How can we proactively find out when a Windows Authentication ID in SQL
Server is no longer valid, i.e. an employee is no longer with the company so
we should delete their related Windows Authentication user IDs from our SQL
Server databases?
MeanOldDBA - 21 May 2006 03:29 GMT
Don't you have an employee table that lists the AD login and whether the
employee is active or not? Some companies store this data directly in AD.
You need to find out where the information is stored though, before we can
tell you how to fix your issue.
Another question...are they disabling the AD account? If you were using AD
groups, instead of individual logins, you would no longer have to worry about
an individuals access. It's also easier to manage and delegate management
responsibility to the business and HR.

Signature
MeanOldDBA
derrickleggett@hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
> How can we proactively find out when a Windows Authentication ID in SQL
> Server is no longer valid, i.e. an employee is no longer with the company so
> we should delete their related Windows Authentication user IDs from our SQL
> Server databases?
Randy - 22 May 2006 15:41 GMT
I found the sp_ValidateLogins very helpful.
To quote the BOL - "Reports information about orphaned Microsoft® Windows
NT® users and groups that no longer exist in the Windows NT environment but
still have entries in the Microsoft SQL Server™ system tables."
Randy
> How can we proactively find out when a Windows Authentication ID in SQL
> Server is no longer valid, i.e. an employee is no longer with the company so
> we should delete their related Windows Authentication user IDs from our SQL
> Server databases?
Stephanie - 22 May 2006 17:18 GMT
Thanks, I'm going to give that a try. It looks like it is exactly what I need.
Stephanie
> I found the sp_ValidateLogins very helpful.
> To quote the BOL - "Reports information about orphaned Microsoft® Windows
[quoted text clipped - 7 lines]
> > we should delete their related Windows Authentication user IDs from our SQL
> > Server databases?