Orphaned Windows authentication

• John Chiu

  SSCrazy

  Points: 2619

  More actions

  August 14, 2006 at 7:43 am

  #169873

  Is anyone know an easy way to identify the orphaned Windows authentication on SQL 2000 server ?

  What hapened is we use NT authentication for several of iur SQl server. As employee terminated, their NT accounts were removed from the NT level but this never happen to their SQL sever account.  I need find a way to identified these 'orphaned' SQL account and purge them.

   

  Thx, 

• Tom Goltl

  SSCertifiable

  Points: 5815

  More actions

  August 14, 2006 at 8:04 am

  #654869

  John,

  sp_validatelogins

  Tom

   

• Claude Hebert Jr

  SSC Veteran

  Points: 269

  More actions

  August 15, 2006 at 5:24 am

  #655031

  -- display orphaned users

  EXEC sp_change_users_login 'Report'

  -- drop a user

  sp_droplogin webuser1

  --- fix a user

  EXEC sp_change_users_login 'Auto_Fix', 'webuser1'