SQL Server Compact - Error The database file is larger than the configured maximum database size

Arthur_Kater · March 31

While trying to connect to a 1GB SQL Server Compact (*.sdf) database, I get the error: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only.

I have added the additional connection string parameter "Max Database Size=4096", which doesn't solve the problem.
Anyone an idea?

JoeAlbahari · April 2

There's an option in the connection dialog to specify the maximum database size. Set that to 4091 and it should allow for the largest database that CE can support.

Arthur_Kater · April 4

Thanks. That worked.

sabuncu · April 6

LOL - 4091! They had to set aside 5 MB for their own use.

SQL Server Compact - Error The database file is larger than the configured maximum database size

Comments