Tuesday, March 25, 2008

CRM Offline Client Connection String

Recently I was getting a SQL connection error when attempting to go offline in the CRM Outlook client (3.0). After scratching my head for little bit trying to figure out a possible cause, it dawned on me. Earlier in the week, our network administrator had changed my pc's machine name (long story). The client must not be able to find the local database due to the machine name change. I popped open regedit and sure enough there were three references to local databases with the incorrect machine name. In the unlikely event that this happens to someone else, they are located in HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient and the keys are:

database
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=MSCRM_MSDE;Integrated Security=SSPI

metabase
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=METABASE;Integrated Security=SSPI

OfflineQueueDBConnection
Provider=SQLOLEDB;Data Source=machinename\CRM;Initial Catalog=MSCRM_MSDE;Integrated Security=SSPI

Just correct the machine name for each, and everything should be back to normal.
Off course, the usual cautions apply about being careful when modifying the registry.

No comments: