Tuesday, March 1, 2016

SID in SQL Server Login and windows login

https://www.mssqltips.com/sqlservertip/2705/identifying-the-tie-between-logins-and-users/


For SQL Server-based login, the SID is generated by SQL Server.

For Windows users and groups, the SID matches the SID in Active Directory.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...