K. Brian Kelley (2/15/2009)
No. While the login name was case-insensitive if your SQL Server has a case-insensitive collation, the password is always case sensitive. This is because of the hashing algorithm used.
I understand your reply but i wonder if you can help.
We recently migrated from Windows SBS 2000 to Windows SBS 2008 as well as SQL Server 2000 to SQL server 2008.
We use an in house software which, when developed, didn't take into consideration the CASE SENSITIVITY for the login (user: sa pass: aBc123) since SQL server 2000 didn't care for the sesnsitivity. The developer realizes now that it was poor software design on his part and is trying to fix it.
In the meanwhile I was wondering if we can run an SQL Query on the SQL SERVER 2008 to tell it not to care for the sensitivity of the user 'sa'.
Something along the lines of:
ALTER LOGIN sa PASSWORD = 'aBc123' COLLATE SQL_Latin1_General_CP1_CI_AS
I know this is not a proper SQL query, but can you suggest anything?