Case sensitive Password check while logging into SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Venkat - 20 Jul 2005 16:30 GMT

Hi,

Is there any way to check the password just to allow into the SQL Server
when it matches with the database password including Case.

My problem is I used a sqlserver connection string to login to my sql
server db. But it is allowing me, even though the user types the password in
any case.

Eg: If i have a password as "pwd" for user "Guest"

It is allowing to enter into the db even the user enters "PWD" or "Pwd"
in any way as the password.

I tried even with Query Analyzer. In that also it is not checking the
password for case sensitive. Is there any way to check the password with
case sensitive. I think the sql server internally should check with case
sensitive for a password.

Please help me.

--
Venkat

Reply to this Message

Narayana Vyas Kondreddi - 20 Jul 2005 19:21 GMT

See if this helps:
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

Signature

HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

> Hi,
>
[quoted text clipped - 19 lines]
> --
> Venkat

Reply to this Message

Venkat - 21 Jul 2005 07:31 GMT

Thanks for your link. But my problem has not been solved.

My problem is why the sql server is checking for a case sensitive
information while logging into the sql server. I am not maintaining any user
tables for passwords. I am just talking about the SQL Server Login using
Query Analyzer.

While logging into the Query Analyzer the password is not validated
using case sensitive. Instead the password is checked using Case-insensitive
mode. It is allowing the user even he typed a mixed case password for a
login which is created using a small case password while creating a user
account.

> See if this helps:
> http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm
[quoted text clipped - 21 lines]
>> --
>> Venkat

Reply to this Message

Dan Guzman - 23 Jul 2005 23:25 GMT

Case-sensitivity for SQL Server login passwords is determined by your
instance default collation. It seems you are using an instance with a
case-insensitive collation.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Thanks for your link. But my problem has not been solved.
>
[quoted text clipped - 34 lines]
>>> --
>>> Venkat

Reply to this Message