Converting SID from Binary to String Active Directory accounts contain the SID in binary form. To convert the byte array into a string representation, use...
# get current user $searcher = [ADSISearcher]"(&(objectClass=User)(objectCategory=person)(sAMAccountName=$env:username))" $user = $searcher.FindOne().GetDirectoryEntry() # get binary SID from AD account $binarySID = $user.ObjectSid.Value # convert to string SID $stringSID = (New-Object System.Security.Principal.SecurityIdentifier($binarySID,0)).Value $binarySID $stringSID
Contact our sales team to get a personalized demo of our database management software for SQL Server!
