Keep a central list of SQL Server logins, and their assigned ID number (“SID”). Standardizing login SIDs across your enterprise prevents the common orphaned users issue.
  • Module: SID Server
  • Job: (None actually; uses CollectorLoginsGet-% and CollectorDBUsersGet-%)
  • Other objects:
    • dbo.SIDServerInsert procedure– inserts a record into the dbo.SIDServer table. 
    • the dbo.SIDServer table
 
This module is supported via the Logins Module jobs and tables, with a couple of exceptions. Common elements:
  • Logins collection uses CollectorLoginsGet-% jobs, running SQLLoginsGet.exe, to populate Collector.Logins.
  • Database Users collection uses CollectorDBUsersGet-% jobs, running DBUsersGET.exe, to populate Collector.DBUsers.
Elements specific to the SID server module:
  • dbo.SIDServerInsert procedure– inserts a record into the dbo.SIDServer table. 
  • the dbo.SIDServer table


Documentation in progress. If we're taking too darn long, ask us for info at Support@MidnightDBA.com