membership/users db location

[Guest]

Hi folks,
I'm using VS 2005 Team system with C# and ASP.net 2.0.
I have an MCSD.Net in 1.1 and relevant commercial experience of ASP.net 1.1

when I click the 'ASP.Net configuration' on the top right of the properties
window and it launches the new web based administration, I can create users
and roles no problem


however it places the database in the app_data directory. (I know this is
for ease of deployment to commercial servers and sql express etc...) this is
my problem


this is what I'd like:
I would like my membership (ASPNET.mdf database) to not be standalone but
rather have its tables somehow inserted into my one and only Data containing
database for the entire application.

Is there anyway to point the configuration tool to my SQL server 2005
installation and get it to add those tables to an existing database?

if so how, and then how does it know which database to administer (I guess
it's an entry in web.config) when I next press on that pesky little icon
'ASP.net configuration'

Regards and thanks in advance,
CharlesA

 

[Guest]

You have to use the aspnet_regsql wizard.
Follow these steps -
1. Go to Command Prompt
2. Go to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
3. Type aspnet_regsql.exe
4. The wizard will open.
5. You can follow the steps to register your database and it will create all
tables and procedures.

You can also automate the process while creating your website. Check the
following article for more information -

http://aspalliance.com/1001_Speed_Up_with_Project_Templates_Using_Visual_Studio_2005__Part_3

 

[Guest]

thanks Ameet, that's exactly the info I was looking for, how did we ever
manager before forums and the brilliantly helpful people on them?

Regards and thanks again,
CharlesA

 

[Guest]

Hi Ameet,

I have register my own database and also i can see a lot tables been creates
for memberhip.

but there are no data existing , i actually create two users and two user
roles throught asp.net configuration.

so just wonder that do i miss sth here?

Cheers

nick sheng