To Find SID of Logins and Users

security-audit
#login#security-audit#user
--for logins select name, sid from sys.server_principals

--for users select name, sid from sys.database_principals