where is the user database?

[dottedquad]

I'm having a hard time finding my newly created users, created by ASP.Net Web Application Administration. Where are they located? Also, is there a way to have the Web Application Administration use my already created database for storing the users?



-Thanks,

Rich

[lmf232s]

Well If you are using the canned connection string then your data should be in a DB that is created for you (Forget the name) but its should reside in your App_Data folder. Its the ASPNETDB.MDF.

I personally do not like it and choose to use sql server instead.

All you need to do to you your own db is to make a couple of changes in your web.config file.

Add a new connection string that points to your db and then modify the membership section of the web.config file. Heres an example. (The line in read is the name of your new connection string to your DB)

<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
<providers>
<add name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="objConn"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
applicationName="SFA"
requiresUniqueEmail="true"
passwordFormat="Hashed"
minRequiredPasswordLength="4"
minRequiredNonalphanumericCharacters="0"
maxInvalidPasswordAttempts="15"/>
</providers>
</membership>

[dottedquad]

Well If you are using the canned connection string then your data should be in a DB that is created for you (Forget the name) but its should reside in your App_Data folder. Its the ASPNETDB.MDF.

I personally do not like it and choose to use sql server instead.

All you need to do to you your own db is to make a couple of changes in your web.config file.

Add a new connection string that points to your db and then modify the membership section of the web.config file. Heres an example. (The line in read is the name of your new connection string to your DB)

<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
<providers>
<add name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="objConn"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
applicationName="SFA"
requiresUniqueEmail="true"
passwordFormat="Hashed"
minRequiredPasswordLength="4"
minRequiredNonalphanumericCharacters="0"
maxInvalidPasswordAttempts="15"/>
</providers>
</membership>

thank you!

-Thanks,
Rich

[lmf232s]

one more thing, if you do decide to use your own DB (and its sql server) then youll need to run a script to create all the aspnet tables in your db.

This is located at
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql

double click on this and it will open a window that will ask you a couple of questions and then it will create all your tables and Stored procedures for the aspnet membership.

[dottedquad]

Thanks! Everything is working smoothly :-)

-Thanks,
Rich

[lmf232s]

No problem, glad you got it up and running.