i had a registration page where i can register the user with password and some other feilds. I am registering Pasword with both uppercase and Lowercase letters. while i am Logging in if i have entered with all Lowercase it is Accepting as a password. i am using Sql server 2008 R2. With C#4.0.
How can i get a Secure authentication for password with both lowercase and uppercase letters
Sanjeeb LenkaPosted Jul 5, 2013, 8:16 AM
SELECT Column1
FROM Table1
WHERE Column1 COLLATE Latin1_General_CS_AS = 'passwrod'
you can use this query at the time of password checking.
if you want more follow this link
http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
Iftikar HussainPosted Jul 5, 2013, 8:15 AM
I suggest to encrypt the password and saved it in database. The encryption will be different for both upper and lower case. You can do encryption by using so many way. Refer below the simplest way to encrypt the data.
http://www.codeproject.com/Articles/10154/NET-Encryption-Simplified
If you want to use in-build SQL Membership provider to create a new user and validate the same, then you will be no need to do any encryption. Below is the link for SQL Memberhsip provider
http://msdn.microsoft.com/en-us/library/6tc47t75(v=vs.100).aspx
Regards,
Iftikar