Use .NET built in login/memership/role security functions

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

Above are two links, very helpful.

I firstly tried using login control, and created users/roles in asp.net website configuration within VS2008 website/asp.net configuration, a web tool to help create user customized key/values in web.config. However, I can not find out where my created user/password is stored.

Finally it's in ./App_Data with aspnetdb.mdf (database file)

Then I hope to integrate this database with the database vote that I am using now.

Through the above two tutorils provided by Sccot Gu, I will be able to integrate move all aspnetdb tables into database "vote".

Tools: asp.net configuration MMC in IIS to check connectionStrings, which is not automatically shown in web.config

Use aspnet_regsql.exe to customize database vote to include those authentication/authorization tables

Add or modify web.config for connectionStrings:

" "




Comments

Aaron Shi said…
(connectionStrings)
(remove name="LocalSqlServer"/)
(add name="LocalSqlServer" connectionString="Data Source=.\SqlExpress;Initial Catalog=vote;Integrated Security=True" providerName="System.Data.SqlClient"/)
(/connectionStrings)"

Popular Posts