What are the two protocols used by SQL Server Windows authentication?

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.

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

add a comment |

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.

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

add a comment |

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.

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

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.

sql-server

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

edited Jan 28 at 19:17

Peter Mortensen

23319

edited Jan 28 at 19:17

Peter Mortensen

23319

edited Jan 28 at 19:17

Peter Mortensen

23319

asked Jan 28 at 14:16

Racer SQL

3,10142562

asked Jan 28 at 14:16

Racer SQL

3,10142562

asked Jan 28 at 14:16

Racer SQL

3,10142562

add a comment |

1 Answer
1

active

oldest

votes

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:

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Understanding Kerberos and NTLM authentication in SQL Server Connections

In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.

...and

Kerberos authentication (protocol) provides a mechanism for mutual authentication between a client and a server on an open network.

^{Comment: emphasis/meaning added}

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f228251%2fwhat-are-the-two-protocols-used-by-sql-server-windows-authentication%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

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:

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Understanding Kerberos and NTLM authentication in SQL Server Connections

In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.

...and

Kerberos authentication (protocol) provides a mechanism for mutual authentication between a client and a server on an open network.

^{Comment: emphasis/meaning added}

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

add a comment |

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:

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Understanding Kerberos and NTLM authentication in SQL Server Connections

In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.

...and

Kerberos authentication (protocol) provides a mechanism for mutual authentication between a client and a server on an open network.

^{Comment: emphasis/meaning added}

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

add a comment |

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:

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Understanding Kerberos and NTLM authentication in SQL Server Connections

In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.

...and

Kerberos authentication (protocol) provides a mechanism for mutual authentication between a client and a server on an open network.

^{Comment: emphasis/meaning added}

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

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:

Questions About Kerberos and SQL Server That You Were Too Shy to Ask

Understanding Kerberos and NTLM authentication in SQL Server Connections

In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.

...and

Kerberos authentication (protocol) provides a mechanism for mutual authentication between a client and a server on an open network.

^{Comment: emphasis/meaning added}

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

edited Jan 28 at 19:18

MDCCL

6,85331745

edited Jan 28 at 19:18

MDCCL

6,85331745

edited Jan 28 at 19:18

MDCCL

6,85331745

answered Jan 28 at 14:47

Josh Darnell

7,26522141

answered Jan 28 at 14:47

Josh Darnell

7,26522141

answered Jan 28 at 14:47

Josh Darnell

7,26522141

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Database Administrators Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu