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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×