locked
SQL timeout expired when search in look up view in CRM 2011 RRS feed

  • General discussion

  • When i choose look up view and reports after starting windows, it triggered properly . After one and half hour, when i choose look up view for search some particular vendor detail and run the report, it showing error. CRM Exception : SQL timeout expired. Give me the solution asap.


    • Edited by meetsathya Thursday, July 17, 2014 6:58 AM
    Thursday, July 17, 2014 6:32 AM

All replies

  • 1. Go to Start > Run, type regedit and click OK
    2. Go to the following registry hive: HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
    3. Right-click MSCRM, point to New, and click DWORD Value
    4. Rename the DWORD to the following value: OLEDBTimeout
    5. Right-click OLEDBTimeout and click Modify
    6. Type 600 in the Value data box and click OK (value could be greater if necessary)
    7. Right-click MSCRM, point to New, and click DWORD Value
    8. Rename the DWORD to the following value: ExtendedTimeout
    9. Right-click ExtendedTimeout and click Modify
    10. Type 1000000 in the Value data box and click OK (value could be greater if necessary)
    Friday, July 18, 2014 2:46 AM