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.

How to do the D365 (IIS-Application) VM/Update-11 backup and restore

To back up and restore IIS 10:

1.    Open cmd.exe.

2.    Navigate to cd c:\Windows\system32\inetsrv

3.    Execute following command to back up configuration:

Create the IIS configuration backup with name d365

c:\Windows\system32\inetsrv> appcmd add backup d365

Press [Enter]

4.    After the command has been executed, a folder with your backup name appears in

c:\Windows\system32\inetsrv\backup. Here are the contents of the website:

·        administration.config

·        applicationHost.config

·        MBSchema.xml

·        MetaBase.xml

·        redirection.config

5.    Copy the backup folder to the same directory c:\windows\system32\backup on another server.

6.    To display the list of all available backups, run the following command:

c:\Windows\system32\inetsrv> appcmd list backup

7.    The backup we have copied has appeared in the list of available backups.

8.    Recover IIS configuration from this backup:

    C:\windows\systems32\inetsrv>appcmd restore backup d365

Note: The string Restored configuration from backup “d365″ means that IIS configuration has been successfully recovered.

The list of restrictions and important issues.

§  The same IIS version has to be used on both servers

§  If any application pool is not run through the integrated accounts, then they have to be available on another server as well

§  Before recovery, you should export and migrate all current certificates to the new server Once, the backup has been restored

How to add new/another user in your D-365 VM (Update 11)

The benefits of other users: this is useful for testing the standard and customized role and workflow scenario (where 2^nd user, as a requester and 1^st user, as an approver)

Note: Internet must be working during this process.

In my scenario:

I have two different email Id – 1^st XXX@outlook.com (will use for as an admin user) and 2^nd XXX@hotmail.com (will use for as a normal user)

1^st I have registered XXX@outlook.com account, hence it will update as an admin account D3655 VM environment.

After successfully registered, login d365 through XXX@outlook.com – email id (as an admin)

XXX@outlook.com is shown as admin user id, it means this user has full D-365 permission.

2^nd/Next steps to add another (XXX@hotmail.com) user id/account.

Create worker with a logical name, this work id will be added in user id later. (User id mapping needed to create the purchase requisition)

Create the workers

Go to users à click new

And update the following information:

Fields details:

User id and nameà as per your wish

Providerà live.com (default and do not change)

Emailà XXX@hotmail.com (active email id)

Telemetry idà only view purpose

Personà Select the newly created worker

Rolesà as per your wish and requirement

I have added below roles to XXX@hotmail.com user.

First sign-out from XXX@outlook.com admin user, therefor login through XXX@hotmail.com user id.

D365-Forms/menus/ modules are visible according to the assigned role of the user (XXX@hotmail.com)

Note: I have added XXX@gmail.com, however, it didn’t work, hence use only MS related (such as outlook, Hotmail etc.) active email accounts only.

D365(VM) -server auto shutdown issue- Fix

First issue: I was encountering the VM-server2016 datacenter, auto shutdown issue tentative every 2 to 3 hrs.

Reason: The Window server 2016 datacenter evaluation version has been expired, hence Server will auto shut down due to this reason (In my case), thus, unable to do the complete D365- full compilation/re-build package because it will take more time and before complete the re-build the server 2016 auto shutdown.

Solution: update valid the window server 2016 datacenter product key in VM/OS.

Second issue: unable to update the product key ion VM/OS. 

             When trying to update the product key through “activate window” button.

 Probably, I was getting the below error because of server is running in evaluation version.

Solution:

Prerequisite: Must have window server 2016 datacenter valid product key.

Step1: go to command prompt (CMD)àRun as administrator.

 Step2: paste the below command along with product key and press enter 

DISM /online /Set-Edition:ServerDatacenter /ProductKey:XXXX-XXXX-XXXX-XXXX-8XDDG /AcceptEula

After upgrade product key, notification has been disappeared

And visible the new product key.

After the product key upgrade, will not find the server auto shut down issue and able to perform the complete AX re-build J

Note: D365 (VM/windows 2016 datacenter) will upgrade only in window server 2016 data center

How to convert and configure D365 Hyper- V (VHD file) in VM ware

Steps1: install VM ware workstation

Steps2: convert the VHD file to VMDK file through ‘WinImage’ or any other convertor. I have used ‘WinImage’  

Refer link for 64 or 32 bits WinImage “http://www.winimage.com/download.htm”

And refer ‘http://www.vmwarearena.com/winimage-convert-hyper-v-vmware-virtual-machine-disk-format/” for Convert Hyper-V to VMware Virtual Machine Disk Format

 

Step3: Crete new virtual machine in VM Ware workstation and select ‘use an existing virtual disk’ VMDK file

Step4: select ‘BIOS’ otherwise the OS (VM Ware /D365) will not start/boot