Hey, I have a question about using the asp.net login control with DASP. In Vs2005 it normally create a new database that handle all the user/logon information. How do you add this to your page when you only have one ms sql database? Do you add all the tables from this database to your DASP database? pay for two databases? Or make your own costum login control? Post Edited (janeirik) : 2/11/2007 10:47:46 PM GMT
You can use the membership provider with the login control to manage authentication. See: http://kb.discountasp.net/article.aspx?id=10413on how to configurethe membership provider.Also,aspnet_regsql.exe creates the required schema and you just need to have one MS SQL database for this. Vikram DiscountASP.NET www.DiscountASP.NET
You typically only need one SQL database until you reach the physical limit. YourSQL database contains individual tables. If a conflict occurs you can use naming schema. Say for example you run a popular forum on your site which creates a table called "Roles". You can create another table in your sites database called my_roles, or public_roles, etc. It's also a good idea to prefix your table names to associate them with your projects. i.e. forum_roles, login_roles, forum_users, login_users, etc.
