Re: Case sensitive Password check while logging into SQL Server

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

  • Next message: Rn: "Encryption and decryption" 
    Date: Thu, 21 Jul 2005 12:01:34 +0530

    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_sensitive_search_in_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
    >>
    >
    >

  • Next message: Rn: "Encryption and decryption"

    Relevant Pages

    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Why CAN I log in?
      ... Get into Query Analyzer however you got into it the first time. ... "bing" wrote in message ... Did you suggest login to SQL ... > installed on the sql server. ...
      (microsoft.public.sqlserver.server)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)