Sometimes Customer Delete DDC from Hypervisor and Active Directory, and then rejoin it to the domain and add the DDC to existing XenDesktop Site. Most often, the rejoining will fail with Error:XDDS:1E9F32BB  Failed to Update database. When checking the details there is another error :Failed to create login [SNDEDU\XDDC02$] for controller [Domain\Servername$] (login may already exist but with the wrong SID)
Restoring SID of DDC from AD or Adding permission of DDC in Database can't solve the issue. You can't creat the site with sql script mannually.

Add the following registry key into DB server 
1. Open Registry Editor, and then locate the following subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
2. Right-click Lsa, click New, and then click DWORD Value.
3. Type LsaLookupCacheMaxSize, and then press ENTER to name the new value.
4. Right-click LsaLookupCacheMaxSize, and then click Modify.
5. In the Value data box, type 0, and then click OK.
6. Exit Registry Editor.
There is no need to restart DB after registry change

---

Problem Cause

MS SID cache issue