SQL Server CE - Internal Error: Unable to open shared memory area

Question

I have a SQL Server CE database that works fine in dev, but there is a problem when installing on the client.

• SQL Server CE 3.5 dependencies are copied as part of the deployment.
• The target machine is a clean 32-bit destination image of Windows 7.

Event Log Exception Message:

Message: Internal error: Cannot open the shared memory region. 
Stack Trace: at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr) at
System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at
System.Data.SqlServerCe.SqlCeConnection.Open() at
System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) at
System.Data.Linq.SqlClient.SqlProvider.Execute(
    Expression query, 
    QueryInfo queryInfo,
    IObjectReaderFactory factory, 
    Object[] parentArgs, 
    Object[] userArgs,
    ICompiledSubQuery[] subQueries, 
    Object lastResult) at
System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(
    Expression query, 
    QueryInfo[] queryInfos,
    IObjectReaderFactory factory, 
    Object[] userArguments, 
    ICompiledSubQuery[]
    subQueries) at
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(
    Expression query) at
System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at 
System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at
System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at
Application specific stuff here

This seems to be SSCE_M_CANTOPENSHAREDMEMORY , and the site says that there is no connection string value to change this value, and that these problems are usually not resolved by the end developers.

Has anyone come across this, and if you could solve this problem?

Answer 1

, CE . VS2010, , SP2 CE.

. SQL Server CE, ADO.NET. ?

, :

• Vista Windows 7;
• SQL Server CE , C:\Program Files C:\Program
  (x86);
• (. )

:

• " "
• , ;
• , .sdf , C:\ProgramData [ ], , ;

• . , "" - EXE .SDF

  , .

Answer 2

.

Windows 7.

, , "" .

% DOMAIN%/Everyone