Can SQL 2005 be changed to accept case-INSENSITIVE passwords???

We have a SQL 2000 server that has been migrated to a SQL 2005 server.
Now when the users log on to the SQL app a lot of them can't logon.
I believe this is due to the SQL passwords being case-insensitve in SQL 2000
and being case-sensitive in 2005. Is there a way to make SQL 2005 passwords
case-insensitive?
Thanks!How did you determine that it is case sensitivity that is causing these
login issues? Are the user names and passwords stored in a table in
the database? Or are the logins defined in SQL Server to use
windows/mixed authentication?
If the user names and passwords are stored in a table in the DB, try
running : "sp_helpsort" in the old and new databases. The result will
tell you if SQL Server 2005 has been set up to use a case sensitive
collation. If it is - you might want to look up how to change
collation so that it is the same as whatever was being used in SQL
Server 2000 - if you want the same behavior in SQL Server 2005.
If defined in SQL Server, run "EXEC sp_change_users_login 'Report'" to
see if any of those logins are out of sync. If they are out of sync,
use this same sp (look it up in BOL) to sync them.
winsysadmin wrote:
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL 20
00
> and being case-sensitive in 2005. Is there a way to make SQL 2005 password
s
> case-insensitive?
> Thanks!|||> Is there a way to make SQL 2005 passwords case-insensitive?
Sorry, but SQL 2005 requires that SQL login passwords be case-sensitive for
security reasons. In SQL 2000, password case sensitivity was determined by
the instance collation. This behavior change is documented in the SQL 2005
Books Online:
<Excerpt
href="ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264
-b547-cbee8013c995.htm">
A password entered by a user must match the password stored in the server.
If a password does not match the password stored in SQL Server, the login
fails. If the precise case of the password characters is forgotten, the
password must be reset.
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"winsysadmin" <winsysadmin@.discussions.microsoft.com> wrote in message
news:369B36BD-BEDC-4EE9-BFFE-F41502EC2D84@.microsoft.com...
> We have a SQL 2000 server that has been migrated to a SQL 2005 server.
> Now when the users log on to the SQL app a lot of them can't logon.
> I believe this is due to the SQL passwords being case-insensitve in SQL
> 2000
> and being case-sensitive in 2005. Is there a way to make SQL 2005
> passwords
> case-insensitive?
> Thanks!