Case sensitive Password check while logging into SQL Server

From: Venkat (tammana_at_inooga.com)
Date: 07/20/05

  • Next message: Joubert Nel: "Restricting domains from which a user can login using SQL Server login" 
    Date: Wed, 20 Jul 2005 21:00:23 +0530

    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
  • Next message: Joubert Nel: "Restricting domains from which a user can login using SQL Server login"