User Authentication For password in Casesensitive.

Question

Hai  My doubt is. 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 Lenka · Answer

hi you have to use this query to for checking case sensitive characters in password. 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 Hussain · Answer

Hi 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