August 12, 2009 at 7:53 am
In SQL SERVER 2000 i am able to use ..but not in 2005
If i have Password like 'JOHN'
Is there a way to use the password ' john '
August 14, 2009 at 1:23 pm
I dont believe you can have case insensitive passwords for SQL 2K5. If this is for an application with which you have control of the code then you should be able to always run a upper/lower case function call to always set, retrieve, send the password the same way.
August 15, 2009 at 10:06 am
Passwords are always Case-sensitive whether you talk abt SQL Server 2000 Or SQL Server 2005.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
August 15, 2009 at 10:15 am
In SQL 2000 passwords were only case sensitive if the server's collation was case sensitive. This means that SQL installed with the default collation on a server with US English regional settings did indeed have case insensitive passwords.
On SQL 2005, all passwords are case-sensitive always. There's no way to make them case insensitive.
See - http://drsql.spaces.live.com/blog/cns!80677FB08B3162E4!1384.entry and http://blogs.msdn.com/lcris/archive/2007/04/30/sql-server-2005-about-login-password-hashes.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2009 at 1:57 pm
And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. That is, if the server gets the password polices from the domain and it is required that your passwords are at least 8 characters, contain at least 1 number - then your password will have to adhere to the same policy.
You can disable that for specific logins - but it is not recommended.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 2:13 pm
Jeffrey Williams (8/15/2009)
And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. That is, if the server gets the password polices from the domain
And if the server is not part of a domain, the password policy defined in the local security policies is applied.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2009 at 2:45 pm
GilaMonster (8/15/2009)
Jeffrey Williams (8/15/2009)
And to further what Gail has stated - in SQL Server 2005, the passwords for SQL authenticated accounts will use the servers password policies by default. That is, if the server gets the password polices from the domainAnd if the server is not part of a domain, the password policy defined in the local security policies is applied.
Oops - yeah, that's what I meant to say. 🙂
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply