Case sensitive Password check while logging into SQL Server

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.
VenkatSee if this helps:
http://vyaskn.tripod.com/case_sensi..._sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Venkat" <tammana@.inooga.com> wrote in message
news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
> 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
>|||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.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> See if this helps:
> http://vyaskn.tripod.com/case_sensi..._sql_server.htm
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> "Venkat" <tammana@.inooga.com> wrote in message
> news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
>|||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.
Hope this helps.
Dan Guzman
SQL Server MVP
"Venkat" <tammana@.inooga.com> wrote in message
news:%232NfH6bjFHA.2852@.TK2MSFTNGP15.phx.gbl...
> 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.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
>