Ok no real problems here I just want to clarify a few things about this database that asp.net defaults too.

What if you have a database already with user information etc, with the creation of the ASPNETDB you would then have 2 and split stored information. Isn't this inefficient and costly dependant on how your service provider charges for databases?

So you would have to copy the relevant information from the old database into the ASPNETDB? Or are you able to specify just to use the old database exclusivly and not have the ASPNETDB.mdf?

This is all hypothetical and something that just popped into my head

Hi Will,

The database is indeed created automatically, unless you tell it otherwise. It's possible (and pretty common) to prepare your own database to work with Membership, Roles and so on. The steps you need to perform are roughly like this:

1. Make sure you have a database for your site

2. Run the tool aspnet_regsql against your database to prepare it for the ASP.NET Services.

3. Tell your application to use this database, instead of the autogenerated one. A quick way to do this (although it feels like cheating) is to override the LocalSqlServer connection string. A bit slower but more correct is to reconfigure the services in your web.config and tell them to use your own connection string.

For a great explanation (and the cheating solution of the LocalSqlServer string) check here:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Once you got that working, take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=481, especially the section "Enable ASP.NET Membership and the RoleManager" where you can see the full code for two services. Once you have that code in your web.config, you can change the reference to LocalSqlServer to your own connection string you use throughout the application.

Probably more information than you wanted, but I hope it helps ;-)

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks alot. I will read through those links when I get a chance tomorrow.