Machine-translated by Google. Questions are authored in English.
Top

Discussion

What mode of authentication does SQL Server NOT provide?

  • A.Windows-only security
  • B.Both SQL Server and Windows-only security
  • C.Mixed security
  • D.SQL Server only security

Answer: D

Correct answer: SQL Server only security

SQL Server offers Windows-only authentication and mixed mode, in which either a Windows account or a SQL Server login may be used. There is no mode that disables Windows authentication, since a Windows administrator can always reach the instance. Windows-only is the more secure of the two available, as the credentials are managed by the domain.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.