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 bymeetsathyaThursday, July 17, 2014 6:58 AM
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)
SQL timeout expired when search in look up view in CRM 2011
