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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2007-03-22 : 10:56:15
|
| I was asked in an interview which is better among windows authentication and sql server authentication? I said windows authentication because, 1. pwd need not be stored in the DB2. windows authentication can have pwd policies. Subsequently I was asked where does O/S stores passwords? Does anyone knows the answer?------------------------I think, therefore I am - Rene Descartes |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-22 : 11:38:01
|
| OS stores passwords in SAM Database(security account manager).in SQL 2005, you can set password policies for standard accounts.Standard authentication is better when you have to cross firewalls and domains(e.g. your web server will invariably have a file/system DSN pointing to the database server using a Standard login only.) This plus a little more like windows logins are trusted connections, which means that you have to be logically allowed to use the network to be able to use the sql server. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-03-22 : 11:55:44
|
| Thank you Paresh!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Authentication