什么是可信连接? [英] What is a Trusted Connection?

问题描述

就 SQL Server 2005(可信与 Windows 身份验证)而言，什么是可信连接?

What is a trusted connection in terms of SQL Server 2005 (Trusted vs Windows Auth)?

推荐答案

可信连接与在 SQL Server 2005 中使用 Windows 身份验证相同.身份验证由域完成，授权由 SQL Server 处理.

A trusted connection is the same thing as using Windows Authentication in SQL Server 2005. Authentication is done by the domain, and authorization is handled by SQL Server.

>

SQL Server 也可以使用自己的登录名，例如 sa 用户.这些都由 SQL Server 进行身份验证和授权.只有在 SQL Server 以混合身份验证模式运行时，它们才可行.

SQL Server can also use its own logins, such as the sa user. These are both authenticated and authorized by SQL Server. They are only viable if SQL Server is run in Mixed Authentication Mode.

MSDN 有一篇关于选择正确的身份验证模式的好文章.这是一本很好的入门书.

MSDN has a good article about choosing the right Authentication Mode. It's a good primer.

这篇关于什么是可信连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！