473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

membership/users db location

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

Oct 2 '06 #1
3 1519
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...o_2005__Part_3

--
Ameet Phadnis
Sr. Technical Consultant
e Tek Global Inc.
"CharlesA" wrote:
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
Oct 2 '06 #2
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
Oct 2 '06 #3
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
"Ameet Phadnis" wrote:
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...o_2005__Part_3

--
Ameet Phadnis
Sr. Technical Consultant
e Tek Global Inc.
"CharlesA" wrote:
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

Feb 13 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Paul Keegstra | last post by:
Hi, I am currently working on an asp.net 2.0 web site that is a replacement of a classic asp web site. The current web site uses a Commerce Server 2002 database for storing user information. ...
3
by: John Chapman | last post by:
Hello, I am trying to use an Access database as the provider for the ASP.NET Membership for the users, roles, and profiles. I have looked at many tutorials available online, and I could not...
4
by: =?Utf-8?B?U2FsYW1FbGlhcw==?= | last post by:
Hi, I am trying to play with the Survey manager application provided gracefully by Microsoft at "http://msdn.microsoft.com/vstudio/express/sql/samples/" VB team(so many thanks), compiled the win...
0
by: Anjan | last post by:
Hi All, I am new to Membership feature in ASP.NET 2.0. I am trying the following scenario. Environment : WinXP SP2 Framework: .NET v2.0, VS.NET 2005. User Data Storage : ADAM. I have an Web...
3
by: Glenn | last post by:
My current classic-ASP site has users, projects, roles and the 2.0 membership looks like a perfect fit, but I'm having trouble finding examples of how to have users that belong to different...
1
by: =?Utf-8?B?ZVByaW50?= | last post by:
Asp.Net v2.0 I have created a web application and I am using it from a single website and database. The web application has different ‘portals’ – each independent and I am using the...
5
by: DotNetNewbie | last post by:
Hi, I am developing an application that has to scale and be very efficient, and I am using asp.net membership in my application. I set things up in my Users table (it has extra columns that I...
8
by: Nick | last post by:
Hi there, Membership.GetNumberOfUsersOnline() works great the first time, then jumps up to the number of users registered in the system. I have tried enumerating through each user individually...
1
by: Jeff | last post by:
Hey ASP.NET 2.0 At work my boss have given me the task of developing a new website. Users will be able to register at the website and gain exclusive access to some information etc... Some...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.