How to change Password from case-sensitive

Question

How to change Password from case-sensitive

Nita Reddy

SSCarpal Tunnel

Points: 4182
More actions
November 5, 2007 at 2:44 pm

#119138

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

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 1

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]

VastSQL SSC-Dedicated Points: 36101 More actions · Answer 2

If u have time change password by using a login having SA privileage.

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 3

Maybe it's time to evaluate the viability of switching over to integrated security?

Austin_123 SSCommitted Points: 1648 More actions · Answer 4

Hi Nita,

I think it's an issue of collation seeting....

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 5

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]

rgambill Grasshopper Points: 15 More actions · Answer 6

Can't you just set the Enforce Password Policy to off (uncheck it)? Assuming that you're using SQL authentication.

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 7

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]

Randall_M. SSC Veteran Points: 258 More actions · Answer 8

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: