MS aspnet database

Is it possible to use the aspnet database on DASP for role-based security via the MS login controls? If not, is there another way of using those controls?

Thanks
John

 

Thanks for the information, Bruce.

Before I try it, does this create a second database that is separately chargable? Ie is there any furcher cost to using it?

John

 

"aspnet_regsql.exe -S DBServerName -U DBLogin -P DBPassword -A all -d DBName" mentioned in the article allows you to specify a target database for the ASP.NET membership / role / profile tables and stored procs which means you can use a single database for both this and your own application related db schema entities without incurring any costs for an additional db.

BTW the same applies if you wanted to use SQL Server to store session state.

 

You really can't use the 'aspnet_regsql.exe' method to create the SQL Session Schema. For one thing it will only create the session schema for .Net 2.0 and not .Net 1.1. Second you'll encounter some permission issue. The 'aspnet_regsql.exe' we put up on the KB is for creating the schema for ASP.Net 2.0 Membership/Roles provider.

 

NICE! Thanks. Took all of 45 seconds to add these tables to my existing database that is in use.

 

Thanks, just what I need.

John