"Could not load file or assembly System.Data.SqlServerCe" error when you configure Microsoft Dynamics CRM for Microsoft Office Outlook

Symptoms
When you try to configure Microsoft Dynamics CRM for Microsoft Office Outlook, you receive the following error message

"There is a problem communicating with the Microsoft Dynamics CRM server. The server might be unavailable. Try again later. If the problem persists, contact your system administrator."

When you click details, the following additional detail is shown:

  Could not load file or assembly 'System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.    at Microsoft.Crm.Application.SMWrappers.CrmSqlCeDatabase.CreateDatabase(Boolean force)
   at Microsoft.Crm.Application.SMWrappers.CrmSqlCeDatabase.Initialize()
   at Microsoft.Crm.Application.SMWrappers.CrmSqlCeDatabase.get_ConnectionString()
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientMetadataSync.GetDataWriteFactoryInstance()
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientMetadataSync.CreateDataWriter[TReturn](Func`2 action)
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientMetadataSync.get_IsValid()
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientDynamicMetadataCache.<>c__DisplayClass1d.<.ctor>b__1a()
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.DeferredMetadataCacheManager.ExecuteWaitUntilReady(Guid organizationId, Action action)
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientDynamicMetadataCache..ctor(IOrganizationContext context, Boolean reloadAsynchronously)
   at Microsoft.Crm.Application.Outlook.ClientMetadataCache.ClientDynamicMetadataCache.LoadCache(IOrganizationContext context, Boolean unusedHere)
   at Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context)
   at Microsoft.Crm.Application.Outlook.Config.OutlookConfigurator.InitializeMapiStoreForFirstTime()
   at Microsoft.Crm.Application.Outlook.Config.OutlookConfigurator.Configure(IProgressEventHandler progressEventHandler
   at Microsoft.Crm.Application.Outlook.Config.ConfigEngine.Configure(Object stateInfo)
Cause
Microsoft SQL Server Compact 4.0 SP1 is not installed. 
Resolution
Install Microsoft SQL Server Compact 4.0 SP1 from the following URL:

http://www.microsoft.com/download/details.aspx?id=30709

More information
If you are still encountering issues connecting CRM for Outlook to your CRM Online organization, a diagnostic tool is available to help diagnose the issue:

CRM for Outlook Configuration Diagnostic
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 3090728 - Last Review: 02/04/2016 00:10:00 - Revision: 2.0

Microsoft Dynamics CRM 2015, Microsoft Dynamics CRM for Microsoft Office Outlook, Microsoft Dynamics CRM 2013, Microsoft Dynamics CRM 2013 Service Pack 1

  • kbmbsmigrate kbsurveynew KB3090728
Feedback