September 30, 2019 at 6:03 pm
I try to be as clear as I can with my explanation.
I stored all of my user's SID as uniqueidentifier coming from OPENQUERY's objectGUID through linked server. They look like: 4998D4F1-2857-4BF6-AF7A-63E6FE3F4A2C.
Within our intranet application I acquire the user's SID as text looking like S-1-5-21-763450472-1037238396-1039276024-1200. I use .net System.Security.Principal.IIdentity object.
I'm trying to update the user information from Active Directory by matching the GUID I stored with the SID I received from the System.Security.Principal.IIdentity object.
I'm using SQL 2008. Made conversions back and forth with binary, hex and text, but for the life of mine I cannot find the match.
Anyone out there can help me out before I go insane?
Any help appreciated,
Ps: Now why the hell this needs to be so difficult? (rhetorical)
September 30, 2019 at 7:43 pm
I believe those are separate attributes of the user in active directory, they don't directly translate back and forth to each other, other than looking up the account by one value and checking the other attribute.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply