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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2006-12-22 : 03:19:29
|
| While i loggin sql query analyser.There is two option windows authentication and another sqlserver authentication.what is the difference between these two |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-22 : 03:29:56
|
Books onlinequote:
Authentication ModesMicrosoft® SQL Server™ can operate in one of two security (authentication) modes: Windows Authentication Mode (Windows Authentication) Windows Authentication mode allows a user to connect through a Microsoft Windows NT® 4.0 or Windows® 2000 user account.Mixed Mode (Windows Authentication and SQL Server Authentication) Mixed Mode allows users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication. Users who connect through a Windows NT 4.0 or Windows 2000 user account can make use of trusted connections in either Windows Authentication Mode or Mixed Mode.SQL Server Authentication is provided for backward compatibility. For example, if you create a single Windows 2000 group and add all necessary users to that group you will need to grant the Windows 2000 group login rights to SQL Server and access to any necessary databases.
Press the F1 key to read more on books online |
 |
|
|
|
|
|
Authentication