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

Discussion

Better security occurs if Windows-only authentication is selected.

  • A.True
  • B.False

Answer: A

Correct answer: True

Under Windows-only authentication the credentials are managed by the domain, with its password policies, account lockout and central administration, and no password is stored or transmitted by SQL Server itself. Mixed mode adds SQL Server logins, which are convenient for applications and non-Windows clients but are one more set of credentials to manage and protect.

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

Post your comment

Please log in or register to post a comment.