5

I was asked this question in an interview, and I have no idea what the answer is.

I know we have Windows authentication mode and SQL Server authentication. But the interviewer said that we have two protocols that Windows verify when using Windows authentication.

I just can't find anything on the Internet about this.

13

They were probably looking for an answer that discuss the "Kerberos" and "NTLM" Windows authentication protocol/schemes.

Once you know what to search for, there are lots of articles online about how these schemes relate to SQL Server:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.