InterviewSolution
Saved Bookmarks
| 1. |
Explain the different authentication modes for a database engine. |
|
Answer» You must choose an AUTHENTICATION mode for the Database Engine during setup. Windows Authentication mode and mixed-mode are the two options. In Windows Authentication mode, Windows Authentication is enabled while SQL Server Authentication is disabled. Both Windows and SQL Server authentication is supported in mixed mode. Windows Authentication is anytime enabled and can't be TURNED off.
|
|