Increase CRM SQL Server Timeout Settings

To increase (or set to a value other than the default), you'll need to modify (or add) a couple of registry keys on the CRM server. For the purposes of this post, we'll assume you need to add the keys.

Open the Registry Editor and create the following DWORD keys in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM hive:

* OLEDBTimeout - Specify the number of seconds for the timeout value. For a 5 minute timeout, you'd select Decimal in the Base option and type a value of 300.
* ExtendedTimeout - Specify the timeout for long-running operations. Select Decimal as the Base and enter a value of 1,000,000. Do not type a value that is larger than 2,147,483,647.