.NET Membership

Question

Hi I am trying out the membership features for .NET and I am using the ASP.NET Web application Administration Tool. My question is where is the user data being stored? I checked my databases and I cannot find it anywhere. I also tried to look for any information within Providers in the admin tool but I still could not locate a path. Can someone help me out? Thanks.

[EDIT] Nothing is in the App_Data folder.

Also I was wondering when I right click App_Data and try to add a database, there is no option to do so. (Add New Item).

Answer 1

I think, it would create a database by name aspnet by default.

Check it :)

Answer 2

have u run aspnet_regsql.exe?

Answer 3

Look for a file called ASPNETDB.MDF in the App_Data folder of your web application project. That's a SQL Express database file.

Edit: Try looking in the App_Data folder in Windows Explorer. It may be on the disk but not showing up in the project inside of Visual Studio.

http://aspnet.4guysfromrolla.com/articles/120705-1.aspx

Answer 4

Check your web.config for the connection string to the database. If it's sql server then there will be a bunch of tables prefixed with 'aspnet_' or something very similar.

Answer 5

It's saved in a database file under your ASP.NET application's App_Data folder.

You can configure it by aspnet_regsql.exe tool to include in your sql server instance :

aspnet_regsql.exe -E -S localhost -A mr

Answer 6

If you need to create the tables and stored procedures for the membership/ roles provider you can open a Visual Studio command prompt (check your start menu) and run aspnet_regsql. The exe is also under the %WINDOWSDIR%\Microsoft.NET\Framework\v2.0.50727\ directory.

It'll enable you to select a database from a running of Server and create everything you need to be getting on with.