Announcements
Hello,
We had to restore our Dynamics CRM 365 Server (VM) on a new network with new users.
That is, the domain has changed and the users have new logins.
So the Deployment Manager can no longer be access as the deployment Administrators no longer exist.
The old domain no longer exists as well.
I have tried using SQL to make changes to the existing ones in the tables: SystemUser and SystemUserRoles
but can still not log in
Any hel is greatly appreciated to get our CRM back up and running
reinstalled and imported
Thank you
Deployment admins can be found with the following query against the config database:
select Name from SystemUser where Id in (select SystemUserId from SystemUserRoles where SecurityRoleId = '19CFBC8D-77ED-459E-9909-1BF1CC1B0430')
If you changed domains -- check what is stored in the SystemUserAuthentication table for the AuthInfo column -- this is the main identifier for the user. The UPN starting with C: for claims authentication and the SID of the user starting with W: for Windows authentication. Update the AuthInfo column to the new SID or UPN with the appropriate prefix (C: or W:).
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156