Convert SID string to varbinary(85)

1 vote

2 answers

3519 views

sql-server ssrs-2012 uuid

                          My ssrs server was moved to a different domain because of which the Users table need to be updated with new SID

current sid: 

    S-1-5-21-39949945-591092532-1226208319-1007

I want to convert this sid into varbinary(85) which would look something like this:

    0x0105000000000005150000005AE2326D3D9AC66DD5CCABEE56040000

I had earlier found a link but unable to find it now.

Any tips?

Asked by Mohammad Yusuf (135 rep)

May 19, 2018, 06:14 AM
Last activity: Apr 7, 2023, 05:04 PM

Convert SID string to varbinary(85)

Related Questions