Unable to load data in the Email Router Configuration Manager

1 . Open SQL Server management studio and run the following query on the MSCRM_CONFIG database:

select nvarcharcolumn, columnname from DeploymentProperties

2 . Note the values in the nvarcharcolumn for the following:

1. ADRootDomainScheme
2. ADSdkRootDomain
3. ADWebApplicationRootDomain

3. Launch Registry editor on the CRM server and check for the hive below:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM[ADRootDomainScheme]: Value should match with noted in step 2-A
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM[ADSdkRootDomain]: Value should match with noted in step 2-B
HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM[ADWebApplicationRootDomain]: Value should match with noted in step 2-C

If the values above do not match, then change the registry values as per the values obtained from SQL in Step 2.

5. Perform an IISRESET on the CRM server and restart the Microsoft Email Router service.

6 . Now launch the Email Router Configuration Manager and click Load Data on Users, Queues and Forward mailboxes.