Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2009-09-11 : 17:57:20
|
Can we make SQL Server 2005 passwords for SQL Server logins case in-sensitive.Venu |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2009-09-11 : 18:48:28
|
How do we turn OFF the password Policy in 2005. We are migrating from SQL Server 2000 to 2005 and we have lot of apps that needs to be changed because of this. There are three check boxes Enforce Password polict which is Unchecked but still the passwords are case sensitive. |
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2009-09-11 : 19:05:19
|
Even after running this the passwords are still case sensitive. Is there a way to make the passwords in SQL 2005 case insensitiveALTER LOGIN Test WITH CHECK_POLICY = OFF Thanks for all the help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|