Re: Are SQL logins case sensitive

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 14:04:32 +0100

Hi Wayne!

I just had to do a test. I have an SQL Server with the standard install ("us" collation, case
insensitive) on my laptop. For security reasons, I do have a password for sa, even though it is only
a test installation. ;-). And, yes, I was able to login using different combinations of upper/lower
case for the password. I.e., case sensitivity for passwords is dependent on the collation in the
master database. :-) 

-- 
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Wayne Snyder" <wsnyder@computeredservices.com> wrote in message
news:uVlDK2Z5DHA.2416@TK2MSFTNGP10.phx.gbl...
> Tibor,
> I thought passwords where case sensitive regardless of the collation... Am I
> mistaken? ( Wouldn't be the first time.  :-)
>
> -- 
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Don Grover" <spamfree@assoft.com.au> wrote in message
> news:e7fFlXT5DHA.2404@TK2MSFTNGP12.phx.gbl...
> > SQL2k
> > Are user passwords case sensitive, ie  Ab234 <> ab234
> > If not can I make this happen?.
> >
> > Don
> >
> >
>
>

Relevant Pages

  • RE: Advice on Create a SQL Server
    ... Use the default collation. ... domain, and running on a windows domain account, it is better to run under ... Windows Authentication mode. ... to SQL Server using a username/password. ...
    (microsoft.public.sqlserver.setup)
  • RE: Advice on Create a SQL Server
    ... Use the default collation. ... Mode" - it depends on how you will be connecting to your database. ... domain, and running on a windows domain account, it is better to run under ... to SQL Server using a username/password. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL_Latin1_General_CP1_CI_AS collation order??
    ... Tibor Karaszi, SQL Server MVP ... "Ward Horsfall" wrote in message ... >> rebuildm.exe) interfaces and a collation designator, ...
    (microsoft.public.sqlserver.setup)
  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... but even MORE generic than the XDb1 implementation, ... disadvantage that 'john', 'John' and 'JOHN' are treated as three distinct ... Since this is the default collation, I assume that your database will use ... I have SQL Server on my desktop; ...
    (comp.object)
  • Re: Russian Language support in SQL SERVER
    ... SQL Server supports languages on a couple of levels. ... specifying a collation defines what language rules are used for ... Cyrillic_general Windows collation that supports the Russian language. ...
    (microsoft.public.sqlserver.server)