基于SQL的问题?紧急要求 [英] SQL based issues? urgent ans required

问题描述

什么是基于Windows的身份验证，基于SQL的身份验证，混合模式.
当基于SQL的身份验证可用时，为什么Microsoft实施基于Windows的身份验证. Windows身份验证与基于SQL的身份验证有什么好处?如果否，为什么会出现.这些身份验证的工作方式.

What is Windows based authentication, SQL based Authentication, Mixed mode.
Why Microsoft implemented Windows based authentication when SQL based authentication is available. Is there any benefit of Windows based authentication on SQL based Authentication.If yes, then what and why sql based authentication is there then? If No, why it is present. How these authentication works.

推荐答案

Windows身份验证的意思身份已作为Windows握手的一部分进行处理，并且现在密码始终不在那儿"以进行拦截.

SQL身份验证意味着您必须自己存储(或提供)用户名和密码，以使其更容易被破坏.使Windows身份验证非常健壮和安全的工作量很大.

混合身份验证是否允许这两者取决于您的要求.


要详细了解，请点击此链接-

http://msdn.microsoft.com/en-us/library/ms144284.aspx [ ^ ]

Windows Authentication means that the identity is handled as part of the windows handashaking and now password is ever ''out there'' for interception.

SQL Authentication means that you have to store (or provide) a username and a password yourself making it much easier to breach. A heap of effort has gone into making windows authentication very robust and secure.

mixed authentication is to allow for both it depends on your requirement .


to understand in detail please follow this link -

http://msdn.microsoft.com/en-us/library/ms144284.aspx[^]

这篇关于基于SQL的问题?紧急要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！