SQL Timeout Expired, MS CRM 2011 Advanced find , more than 2 minutes RRS feed

  • Question

  • Hi All,

    when I am doing a advanced find, and it takes more than 2 minutes, then I get SQL timeout expired.

    exactly what I am doing is, I am searching in activities entity, description field.

    if the result comes (either any record or blank) before 2 minutes, then no issue, but if it goes more than 2 minutes then immediately I get this error.

    I have tried with all the time setting like SQL remote connection, MS CRM registry keys like OLEDBTimeout, ExtendedTimeout, NormalTimeout, also all the sandbox time out...

    but no luck...

    anyonehas any idea... appreciate....

    here the event logs ...



    Friday, August 8, 2014 4:41 AM