Last post Sep 10, 2013 08:36 AM by mshoaiblibra
Sep 10, 2013 01:19 AM|collo|LINK
Hai, I am new at creating a registration page, but I would like to know, where is the ideal place to store the username and password? I know there are a few places, MS Access, SQL Management Studio. But which one is suitable for a website where other people
will be registering or login? Can I store the data inside SQL Server Database, created using MS Visual Web Developer 2010?
Sep 10, 2013 01:37 AM|Abhishek Luv|LINK
Yes. SQL Server Database. You have 3 options
1. SQL Server Compact Database - File-based Database
2. SQL Server Express
3. SQL Server Developer or Enterprise Edition.
If you are using SimpleMembershipProvider then Usernames will be stored in the UserProfile table and Password will be stored in the webpages_membership table.
Sep 10, 2013 08:28 AM|Mikesdotnetting|LINK
I advise using a suitable Membership Provider to manage this for you. The default membership provider for ASP.NET is SqlMembershipProvider. You can also use SimpleMembershipProvider via the WebSecurity class. The first one requires a SQL Server database,
and the second one will work with SQL Server or SQL Compact Edition. SqlMembershipProvider creates a lot of tables and stored procedures. SimpleMembershipProvider creates a few tables and does not need stored procedures. SqlMembershipProvider allow you to
store passwords in plain text, although it provides an option to store them as hashed values too. SimplelMembershipProvider will only store hashed values, making it more secure.
Sep 10, 2013 08:30 AM|Mikesdotnetting|LINK
1. SQL Server Compact Database - In-Memory Database
SQL Compact Edition is not an in-memory database. It's a file-based system (similar to Access) that runs in the same process as the web application.
Sep 10, 2013 08:36 AM|mshoaiblibra|LINK
You can use also another option:
Just read below article for Securing Passwords in Your Database.
Also Read Storing Sensitive Information Using ASP.NET:
Hope you'll get another idea.