Open your user record in Microsoft CRM and copy your user id (Ctrl + N), --Step 1b SELECT Id, UserId FROM [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] WHERE CrmUserId = '7C0EAC14-0284-E111-942D-00155D017404' --replace '7C0EAC14-0284-E111-942D-00155D017404' with your real user id from step 1a --Step 2 run update command INSERT INTO [MSCRM_CONFIG].[dbo].[SystemUserRoles] ([Id], [SecurityRoleId], [SystemUserId], [UniqueifierId], [IsDeleted]) VALUES ('id from above', '19cfbc8d-77ed-459e-9909-1bf1cc1b0430', 'userid from above', NULL, 0) --Step 3 update another table with the user's windows domain name update Systemuser set name ='domain\user' where id='7F0EAC14-0284-E111-942D-00155D017404' |
Dynamics CRM >