Differences between Windows Authentication and Hybrid Authentication

Source: Internet
Author: User

Differences between Windows Authentication and Hybrid Authentication
The two authentication methods are different mainly in trust connections and non-trust connections.

Windows authentication is more secure than Hybrid Authentication. When using this connection mode, SQL does not judge the sa password, but performs authentication only based on the user's windows permissions. This is called "trusted connection ", however, during remote connection, you cannot log in because of NTML authentication (an authentication method for the NT System.


Hybrid Authentication means that when a local user accesses SQL, windows authentication is used to establish a trusted connection. When a remote user accesses SQL, windows Authentication fails, for SQL server Authentication (sa users can also log on to SQL), and establish a "untrusted connection", so that remote users can log on.


More directly, it is windows authentication. If the sa password is not verified and the windows logon password is incorrect, you cannot access SQL. in hybrid mode, you can use windows authentication to log on, you can log on remotely using the sa password.


To be accurate, the Hybrid Authentication mode is based on Windows identity authentication and SQL Server identity Hybrid Authentication. In this mode, the system determines whether the account is trusted in the Windows operating system. For trusted connections, the system uses Windows Authentication instead of trusted connections, this connection includes not only remote users but also local users. SQL Server automatically verifies the connection by the existence of the account and password matching. For example, when an SQL Server instance runs on Windows 98, hybrid mode is required because Windows 98 does not support Windows Authentication mode.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.