Sunday, May 27, 2018

What if change the user id in the SQL table in D365 (VM/update 11- environment)




I have registered XXX@hotmail via AdminUserProvisioning




Open D365 via XXX@hotmail user id


XXXX@hotmail.com shown as an admin user ID



And the top right corner also shown XXX@hotmail.com as well

Open the “USERINFO” table in SQL.

 Go to the “admin” line


Scroll right side 

Note: under “NETWORKALIS” has been updated XXX@hotmail.com user id. This is updated by “AdminUserProvisioning”

Now, manually changed the XXX@hotmail to XXX@outlook.com


Save and Close the SQL

Now, open the D365 again.
Question: in which login ID (XXX@hotmail.com or XXX@outlook.com), D365 will open


I believe, most of people will think, D365 will open through XXX@outlook.com, however, it is incorrect, reason is, I believe, D365 first check the Azure AD and in AAD the registered user ID is XXX@hotmail.com


1: Login- through XXX@outlook.com



Getting following error, when trying to login through XXX@outlook.com



2: Login- through XXX@hotmail.com



Now, D365 has been opened with the XXX@hotmail.com




However, it is shown XXX@outlook.com as an admin user id, instead of XXX@hotmail.com.



And top right also shown XXX@outlook.com, instead of XXX@hotmail.com
Reason: XXX@outlook.com user id pulls from the SQL, instead of AAD






Bottom line:

During D365 login, internet is needed to validate the login credential (AAD), once logged in the D365 environment, need not require internet connection



Now, I have disconnected/disabled the internet


Still, able to work on D365, without any interruption and posted the below JV.



No comments:

Post a Comment