Reconciling database users with Active Directory

• Jason Marshall

  SSCommitted

  Points: 1791

  More actions

  May 7, 2008 at 12:50 pm

  #190028

  Good afternoon everyone-

  This probably could have been posted in 'Security', but here goes:

  We use Windows Authentication to grant access to Reporting Services and user databases. We would like to perform quarterly audits to reconcile our Reporting Services and database users with Active Directory to find any accounts that are inactive (in Active Directory) so we can remove them from our databases.

  Has anyone done this, or know of a way to do this?

  Thanks!

  Jason

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  May 7, 2008 at 1:52 pm

  #812049

  You may turn on the audit for login in SQL Server.

  Check the log file and remove the inactive logins.