SQL CE by design is prevented to run under ASP applications. You can imagine a single file database is not really a scalable solution. However, there are scenarios that you way want to do that. I know it is silly.
Using SQL Compact Edition Under ASP.NET | Zorched / One Line Fix