SQL Server logins can be based on Windows Operating System security or SQL server-specific security.

Name: SQL Server logins can be based on Windows Operating System security or SQL server-specific security.
Brand: Quizplus
Rating: 4.8 (31 reviews)

Question

Quizplus · Accepted Answer

SQL Server offers two types of logins - Windows Authentication mode and Mixed Mode Authentication. Windows Authentication mode uses Operating System security to authenticate users while SQL Server specific security uses its own security system to maintain logins.

SQL Server Logins Can Be Based on Windows Operating System