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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-07-02 : 10:34:17
|
| Hi All,what is the difference between Windows authentication and SQL Authentication? what are the advantages and disadvantages in between these thwo?this is an interview question can you please let me know...ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-02 : 10:39:04
|
here
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-07-02 : 12:58:03
|
| 1- Windows Authentication ModeIn Windows mode users who have access to particular domain can connect to it you do not have to specify a login name and password, to connect to SQL Server. here server will manages all activities but certain time if there is network connection problem, you cannot access from windows authentication mode (Window authentication ex- lotus notes, outlook express) Works best when the database is accessed within the organization only2 - Mixed Mode Authentication ModeIn Mixed Mode users from both Windows Mode and Sql Server Authentication can login. Sql server logins means users from private network or outside of companies network.In Mixed Mode dba has to create Login and Password for sql server authenticationWorks best when outside users may access the database or when you don't use Windows domains |
|
|
|
|
|
|
windows authentication and sql authentication