SQL Timeout solutions in Dynamics CRM 2011

Mostly this kind of problems could come from Plugins, if there are any plugins executed on that action.

Increase the default timeout

Registry on CRM applicationserver(s)

1. Open CRM Web Server(where CRM is installed)
2. Open regedit (start – > write ( regedit) ) and press ok
3. Go to HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSCRM
4. Add DWORD name OLEDBTimeout with value 86400 ( 24 hours) select decimal
5. Add DWORD name ExtendedTimeout with value 1000000. The maximum value can be 2,147,483,647 and the default value is 30 seconds

These changes in register should fix the SQL timeout.