Integrated Security = True 和 Integrated Security = SSPI 有什么区别?

2021-12-02 00:00:00 security sql-server connection-string database-security

我有两个使用集成安全性的应用.一个在连接字符串中分配Integrated Security = true，另一个设置Integrated Security = SSPI.

I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated Security = SSPI.

SSPI 和 true 在集成安全上下文中有什么区别?

What is the difference between SSPI and true in the context of Integrated Security?

推荐答案

根据 Microsoft 它们是一回事.

According to Microsoft they are the same thing.

当false 时，在连接中指定了用户 ID 和密码.如果为 true，则使用当前的 Windows 帐户凭据进行身份验证.
识别的值是 true、false、yes、no 和 sspi(强烈推荐)，相当于 true.

When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.

相关文章