November 5, 2007 at 2:44 pm
I am upgrading SQL server 2000 to 2005 we have 100 of servers.
Our password is Not-Case sensitive in 2000 when I migrate it is case-sensitive and facing lot of problem.
Do anyone knows how to change this to non-case sensitive or is there any way to turn off the password.
Nita
November 5, 2007 at 3:27 pm
Unfortunatly I ran into exactly the same problem. The answer is that there is no way to tell SQL 2005 to be non-case sensative when it comes to passwords.
My suggestion to you is to have everyone re-do their passwords as all upper or all lower case and adjust accordingly.
Sorry for passing on the bad news.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
November 6, 2007 at 8:22 am
If u have time change password by using a login having SA privileage.
November 6, 2007 at 9:26 pm
Maybe it's time to evaluate the viability of switching over to integrated security?
November 6, 2007 at 10:00 pm
Hi Nita,
I think it's an issue of collation seeting....
November 7, 2007 at 4:12 am
The collation setting only affects the passwords in SQL 2000. In SQL 2005 the passwords are case sensative and there is no way to change it.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 8, 2008 at 9:55 am
Can't you just set the Enforce Password Policy to off (uncheck it)? Assuming that you're using SQL authentication.
October 8, 2008 at 10:05 am
rgambill (10/8/2008)
Can't you just set the Enforce Password Policy to off (uncheck it)? Assuming that you're using SQL authentication.
Unfortunatly that just sets the rules for password creation. The password verification is still case sensative.
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 24, 2013 at 11:29 am
Thanks bunches Ken, I just got hit with this problem and management was ready to give me the third degree about it.
Drive it like you stole it[/size] :w00t:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply