Fixing AD issues for CRM

select

 crmuserid  --reference to the SystemUserId in CRM
,suo.userid  --reference to the SystemUserAuthentication table

,AuthInfo
,domainname
,fullname

,sua.Id


from

[MSCRM_CONFIG].[dbo].SystemUserOrganizations  suo

LEFT JOIN [MSCRM_CONFIG].[dbo].SystemUserAuthentication sua
ON suo.UserId = sua.UserId


LEFT JOIN Row2015_MSCRM.dbo.systemuser su
ON suo.CrmUserId = su.SystemUserId

where
suo.OrganizationId =
(
select ID from MSCRM_CONFIG.dbo.Organization where UniqueName = 'Row2015'
)


and su.DomainName like '%Xacv622test1%'

--W:S-1-5-21-1659004503-2025429265-725345543-164647
--W:S-1-5-21-1659004503-2025429265-725345543-184821


update [MSCRM_CONFIG].[dbo].SystemUserAuthentication
set AuthInfo = 'W:S-1-5-21-1659004503-2025429265-725345543-184821'

where id = 'A3E25B91-97EB-E511-80D3-005056AC11FA'

$objUser = New-Object System.Security.Principal.NTAccount("DOMAIN", "USERNAME") 
$strSID = $objUser.Translate([System.Security.Principal.SecurityIdentifier]) 
$strSID.Value

http://www.celedonpartners.com/blog/reconnecting-active-directory-accounts-in-dynamics-crm/