Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
imtu_174
Starting Member
9 Posts |
Posted - 2005-10-05 : 17:45:48
|
HiHow does SQL Server encrypt the user's passwords in the syslogins table (SQL Server 2005) ?We have a Java Middle Tier that needs to communicate to my sql server database. How is the authentication done ?How can you check if the username/password combination is valid ?Or how do u know username/(encrypted password) is valid ?Thanks in advance... |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-05 : 17:52:53
|
To check if it is valid, you attempt to make a connection to the SQL Server using his/her credentials. If you get the Login Failed error message, then you know the combination is invalid.Tara |
|
|
|
|
|