vanilla application template created using:
File -> New Project -> ASP.NET MVC 4 Web Application -> Internet Application (Razor View engine)
The only change made is to the database and file name in the connection string in web.config.
With database for SimpleMembership, created by running the application

Simply browsing to the home page will not cause creation of the database, that requires calling a method on the AccountController (in order to cause initialization of SimpleMembership through the InitializeSimpleMembership attribute -> SimpleMembershipInitializer constructor -> ObjectContext.CreateDatabase() call)