Table aspnet_User not being used in FormsAuthentication

Posted on 2009-02-17
Medium Priority
Last Modified: 2012-06-27
I created the tables for Forms Authentication by running aspnet_regsql. I put in the settings in the Web.Config (see below).
Yet when I create Users on the Web Site Administration Tool (WAT), it does not add the data in the aspnet_User table. And if I programatically add users, they do not appear in the WAT.

When I look in the WAT, the provider is AspNetSqlProvider, as in the web.config.

Clearly the 2 are not communicating, but I cannot see why. What could I be doing wrong?
          <add connectionStringName="ResourceManagerConnectionString" enablePasswordRetrieval="false"
             enablePasswordReset="true" requiresQuestionAndAnswer="false"
             requiresUniqueEmail="true" name="AspNetSqlProvider" type="System.Web.Security.SqlMembershipProvider" />

Open in new window

Question by:hijiki7777
LVL 12

Assisted Solution

techExtreme earned 800 total points
ID: 23662509
I assume you are using sql server for storage. However still if there is a database file with extension .mdf in  your app_data folder, can you open it and confirm that your users are actually not created therein instead of the server?
LVL 41

Accepted Solution

guru_sami earned 1200 total points
ID: 23662743
As mentioned by techExtreme: you can find the aspnetdb.mdf under app_data folder which is being referenced.

Modify your membership Settings like below:

Make sure the ConnectionString  is pointing to the database where you have aspnet_users tables.

<membership defaultProvider="ResourceManagerConnectionString">
<add name="ResourceManagerConnectionString"
type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Author Closing Comment

ID: 31548182
Well done techExtreme and Guru sami for helping me with this. Tech pointed out what the problem was, and Guru came up with the solution.
Thank you very much both of you.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month9 days, 13 hours left to enroll

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question