Reconciling database users with Active Directory

  • 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

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

    Check the log file and remove the inactive logins.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply