Hi Imar,
Its a nice approach that you came up with this book.
I am able to configure these sample projects for
SQL2005 Enterprise Edition rather than SQLExpress as given.

Here is a small confusion that, Is multiple ASPNETDB databases (configuration databases for each application) would be there when multiple web applications hosted on single machine - (assume that all applications' databases hosted on single sqlserver)

I tried opening Web Site Administration Tool for two of hosted sites on my machine, shows common users, roles. and I found single entry for aspnet_Applications table In SQL server.

please advice me ..

 thanks in advance

Hi sanindia,

I am not sure I understand what you're asking.

If you have multiple web sites that share the same ASPNETDB database, each application will have its own *record* in the aspnet_Applications table. So, you'll only see a single table, but with multiple records.
Each user / Membership user is then linked to a single application based on the ApplicationId which is the primary key of the aspnet_Applications table.

Does this help?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks for your reply.

I got the exact answer.
The only doubt about, how the runtime will make an entry in aspnet_Application table for a newly hosted application on the server, when we host multiple applications? what is the process to do this?

For example, I have Two applications. hosted on my machine.
Both are Internet based application using Forms authentication.
So, I should have two entries in my appnet_Applications tables.
But It shows only one entry that is related to first configured application.
when I open Web Admin Tool for the second application. still it shows same users & roles that were configured for first application.

please help me in this.

--SAN

Hi there,

The application name is determined by the applicationName attribute on a provider element in the web.config.

Take a look here for more info: http://msdn2.microsoft.com/en-us/library/ms164654.aspx

So, if you give two apps two different application names, they'll end up as two records in the aspnet_Application table.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.