Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some major points to absorb from this: A login is created at the SQL Server instance level. We say it’s an instance-level object. A user is created at the database level. It’s a database-level object. The SID is the server ID – a … Continue reading SQL Server logins, users, SIDs, and orphaned users – a quick primer
The post SQL Server logins, users, SIDs, and orphaned users – a quick primer appeared first on The MidnightDBA Star-Times.