If your machine is not showing any SQL Server Compact edition installed, then its a strange thing because it is the prerequisite for Microsoft Dynamics CRM for Outlook to install.
Please follow the below steps:
1.Install SQL Server CE 4.0. To do this, visit the following Microsoft website:
www.microsoft.com/.../details.aspx
Notes-
+ This step requires elevated permissions.
+ In SQL Server CE 4.0, 64-bit clients do not have to install the 32-bit version.
2.Add the following XML code under the configuration element in the CrmClient{14B13B7A-CA08-40bd-AC60-8C45367E807C}.config file that is located in the Program Files\MSCRM\Client folder:
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845dcd8080cc91" culture="neutral" />
<bindingRedirect oldVersion="3.5.1.0"
newVersion="4.0.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
Notes-
+ This step requires elevated permissions.
+ Make sure that you add this code before the </configuration> tag.
3.Additionally, there is a second configuration file that the configuration wizard calls. The file is named Microsoft.Crm.Application.Outlook.ConfigWizard.exe.config, and the file is located in the C:\Program Files\Microsoft Dynamics CRM\Client\ConfigWizard folder:
<configuration>
<startup>
<supportedRuntime version="v4.0.30319" />
</startup>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="..\bin"/>
<dependentAssembly>
<assemblyIdentity name="System.Data.SqlServerCe"
publicKeyToken="89845dcd8080cc91"
culture="neutral" />
<bindingRedirect oldVersion="3.5.1.0"
newVersion="4.0.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
<system.net>
<defaultProxy useDefaultCredentials="true" />
</system.net>
</configuration>
4.Delete all SDF files in the %localappdata% and %appdata% folders.
List of databases in CRM
- %LocalAppData%\Microsoft\MSCRM\Client
- CrmCache.sdf
- {Guid}[true|false].sdf
- %AppData%\Microsoft\MSCRM\Client
- EmailCache.sdf
- OutlookSyncCache.sdf
Verification steps
To verify that you applied the resolution correctly, follow these steps:
1.Start Outlook after you perform all the steps from earlier in the "Resolution" section.
2.Make sure that the Microsoft Dynamics CRM plug-in starts correctly.
3.Start the Process Explorer tool. To download Process Explorer, visit the following Microsoft website:
technet.microsoft.com/.../bb896653.aspx
4.Find the Outlook.exe process, and then double-click it.
5.Select the .NET Assemblies tab, and then expand AppDomain: SharedDomain if it is not expanded already.
6.Find System.Data.SqlServerCe in the list. Make sure that the path contains the following version of SQL Server CE:
C:\windows\assembly\GAC_MSIL\System.Data.SqlServerCe\4.0.
Note If the path contains SQL Server CE 3.5.1.0, assembly redirection will not work.
