SQL Server Logins
Hi
Currently using SQL server 2000
Is there a way of making SQL server logins use case sensitive passwords.
for example user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password.
I have read about changing the collation to "CS_AS" on the DB , but that comes up with errors as there are triggers which are using the existing collation.
Would appreciate some help on this. Thank you very much.
Software/Hardware used:
SQL server 2000
Currently using SQL server 2000
Is there a way of making SQL server logins use case sensitive passwords.
for example user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password.
I have read about changing the collation to "CS_AS" on the DB , but that comes up with errors as there are triggers which are using the existing collation.
Would appreciate some help on this. Thank you very much.
Software/Hardware used:
SQL server 2000
ASKED:
May 26, 2011 10:09 AM
UPDATED:
January 15, 2012 1:12 AM
Answer Wiki:
SQL Server 2000 is case insensitive by default due to collation and sort order. You can change collation after setup but it is important to use the correct collation settings and you must rebuild the databases and reload the data. It is also recommended that you develop a standard within your organization for these options as many server-to-server activities will fail as you pointed out if the collation settings are not consistent across servers. Proceed with caution or upgrade to SQL Server 2005/2008 where passwords are case sensitive by default.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
