SQL Server Performance Forum – Threads Archive
SQL Authentication Password Case sensitivity
Whenever we use the SQL Server Authentication to connect to the SQL Server, the password we supply, is it case sensitive or we have to set some option to make it case sensitiveno it is not case sensitivity
AFAIK the password for a SQL login IS case sensitive.
Are you sure???
my sa password is ADTSA but i tried by using different combinations
adtsa, aDtSa
all works!!!
I agree with Adriaan as at our end they are.
It is recommended to have mixed case passwords with a few numbers. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
my server is also works even when i tweak my ‘SA’ password . thus i am also agreed with dinesh password is not case sensitive. hsGoswami
[email protected]
As far as I know passwords are case sensitive if you selected a case sensitive collation during install (thus affecting the master database). If you selected a case insensitive collation you have case insensitive passwords.
I agree with Agryle, Password is case-senstive or not totally depend on collation settings of SQL server. To find what collation settings are active on SQL server use below SP. sp_helpsort
Displays the Microsoft® SQL Server™ sort order and character set.
This is the result set. Server default collation
————————
Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data. Deepak Kumar –An eye for an eye and everyone shall be blind
yeap, i got it
SELECT * FROM ::fn_helpcollations() will list collates with their case sentinveness
thankx guys
]]>