Are SQL logins case sensitive

SQL2k
Are user passwords case sensitive, ie Ab234 <> ab234
If not can I make this happen?.
DonIt depends upon the Collation you are using.
If you are using Dictionary Order Case Insensitive, which is the default, I
guess it should not make a difference.
--
HTH
Satish Balusa
Corillian Corp.
"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
>|||I tried BOL, but it does not specify case sensitive.?
Im also wondering what characters can only be entered by the keyboard etc,.
and not through a sp or the like.
Don
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:uwThpdT5DHA.1632@.TK2MSFTNGP12.phx.gbl...
> It depends upon the Collation you are using.
> If you are using Dictionary Order Case Insensitive, which is the default,
I
> guess it should not make a difference.
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "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
> >
> >
>|||> I tried BOL, but it does not specify case sensitive.?
Can you expand on above? I don't understand what you are asking. What Satish were getting at is that
whether passwords are case sensitive or not depends on the collation you selected when you installed
the SQL Server. If you selected a case sensitive collation or a binary collation, then the passwords
are also case sensitive.
> Im also wondering what characters can only be entered by the keyboard etc,.
> and not through a sp or the like.
Again, I'm not sure what you are asking.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Don Grover" <spamfree@.assoft.com.au> wrote in message news:ujdZn7U5DHA.2764@.TK2MSFTNGP09.phx.gbl...
> I tried BOL, but it does not specify case sensitive.?
> Im also wondering what characters can only be entered by the keyboard etc,.
> and not through a sp or the like.
> Don
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:uwThpdT5DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > It depends upon the Collation you are using.
> > If you are using Dictionary Order Case Insensitive, which is the default,
> I
> > guess it should not make a difference.
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "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
> > >
> > >
> >
> >
>|||Don
Look at below examle helo to solve the problem
create table ABCD
(
[password] varchar(20) null
)
insert into ABCD([password])values ('ABCD')
DECLARE @.p VARCHAR(100)
SET @.p='AbcD'
SELECT [password] FROM ABCD
where charindex(cast(@.p as varbinary(20)),cast([password] as
varbinary(20)))> 0
SELECT [password]
FROM ABCD
WHERE [password] =@.p COLLATE Latin1_General_BIN
SELECT [password]
FROM ABCD
WHERE charindex(@.p,[password] COLLATE Latin1_General_BIN)>0
drop table ABCD
"Don Grover" <spamfree@.assoft.com.au> wrote in message
news:ujdZn7U5DHA.2764@.TK2MSFTNGP09.phx.gbl...
> I tried BOL, but it does not specify case sensitive.?
> Im also wondering what characters can only be entered by the keyboard
etc,.
> and not through a sp or the like.
> Don
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:uwThpdT5DHA.1632@.TK2MSFTNGP12.phx.gbl...
> > It depends upon the Collation you are using.
> > If you are using Dictionary Order Case Insensitive, which is the
default,
> I
> > guess it should not make a difference.
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "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
> > >
> > >
> >
> >
>|||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
>|||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
> >
> >
>