Friday, May 1, 2015

Custom report from Dynamics CRM takes long time to load

When triggered custom report from CRM, it takes long time to run. It will display the report but it just takes some time. This is due to CRM and SSRS seeking authentication from Active Directory. If the AD is slow, this will affect the performance.

To solve this issue, make sure the AD is reachable (preferable on the same subnet), then create/set registry key on both CRM and SSRS server for a preffered Domain Controller,

HKLM\Software\Microsoft\MSCRM registry hive

    • Name: PreferredDC
    • Type: String
    • Value: <DC_Name>

No comments:

Post a Comment