Re: Case sensitive Password check while logging into SQL Server
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 07/24/05
- Previous message: Hari Prasad: "Re: User rights problem"
- In reply to: Venkat: "Re: Case sensitive Password check while logging into SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 23 Jul 2005 17:25:22 -0500
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... >> 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 >>> >> >> > >
- Previous message: Hari Prasad: "Re: User rights problem"
- In reply to: Venkat: "Re: Case sensitive Password check while logging into SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
