I am confused now over where the database for Forms Authentication is.
I started a new MVC 4 application using the standard Internet template. There is no MemberShip section in web.config. All I had was <authentication mode='Forms'> and things just worked. When I logged in for the first time, automatically five new tables (UserProfile, webpages_Membership, webpages_OAuthMembershiop, webpages_Roles and webpages_UserInRole) were created in the database at the connection string DefaultConnection*. This was actually my application database. These new tables seem to contain the correct membership information.
The logging in and out worked fine. But now I wanted to add Roles. When I go to the ASP.NET Web Site Administration Tool, things broke down as it could not find the stored procedure 'dbo.aspnet_checkSchemaVersion'. When I ran aspnet_regsql a new aspnetdb database was created with a different set of tables from those fiv ...
Go to the complete details ...