Re: Case sensitive Password check while logging into SQL Server

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/20/05 

Date: Wed, 20 Jul 2005 19:21:56 +0100

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
>

Relevant Pages

  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.inetserver.iis.security)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.win2000.security)
  • Re: unable to connect to sql db
    ... well, I'm not going to show my actualy Id and pwd, but yeah I have the id ... and password on my sql server, and I gave it dbowner permission for the ... 'login failed for user 'username' ... this same connection string works on DBServerDev fine with the same ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Database security (non-existent?)
    ... I run sqlcmd without specifying any username or pwd, ... *HUGE* security flaw - unless, ... BTW, based on this and your other post, I would highly recommend you pick ... done correctly SQL Server 2005 is pretty much as secure as ...
    (comp.databases.ms-sqlserver)
  • Re: Database security (non-existent?)
    ... I run sqlcmd without specifying any username or pwd, ... (admittedly I dropped only the dbs I created). ... security flaw - unless, ... done correctly SQL Server 2005 is pretty much as secure as ...
    (comp.databases.ms-sqlserver)