Summary: I am trying to use asp.net membership, roles, and profiles, but am having trouble getting my code to use the tables generated by aspnet_regsql.exe.
What I tried:
- Ran aspnet_regsql.exe on my database. This worked and all the tables were created.
- Called
Membership.CreateUser("tester7","tester7","tester7@hi.com");
This then created the following tables and stored the user in dbo.Memberships instead of dbo.aspnet_Memberships.
- dbo.Applications
- dbo.Memberships
- dbo.Profiles
- dbo.Roles
- dbo.Users
- dbo.UsersInRoles
It completely ignored the tables created by aspnet_regsql.exe.
Why is this happening and what can I do to target to aspnet_* tables?
Edit to include Web.config Membership registration
<membership defaultProvider="ProjectMembershipProvider">
<providers>
<add name="ProjectMembershipProvider" type="System.Web.Providers.DefaultMembershipProvider,..." connectionStringName="ProjectSql" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="Project" />
</providers>
</membership>