集成安全性= SSPI在连接字符串中的含义 [英] What does Integrated Security =SSPI means in the Connection string
本文介绍了集成安全性= SSPI在连接字符串中的含义的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我是Ado.net的新手。任何人都可以告诉我集成安全性= SSPI在连接字符串中的含义。如何连接是在这里制作？
问候
Chaithanya M
Hi,
I am new to Ado.net.Can anyone please tell me what does Integrated Security=SSPI means in the connection string.How the connection is made here?
Regards
Chaithanya M
推荐答案
查看 http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v = VS.100）.aspx [ ^ ]
集成安全性或Trusted_Connection
虚假时，用户在连接中指定了ID和密码。如果为true，则使用当前Windows帐户凭据进行身份验证。
识别值为true，false，yes，no和sspi（强烈推荐），这相当于如果指定了用户ID和密码，并且Integrated Security设置为true，则将忽略用户ID和密码，并使用Integrated Security。<真实。
/ i>
Check out http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(v=VS.100).aspx[^]
"Integrated Security" or "Trusted_Connection"
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.
If User ID and Password are specified and Integrated Security is set to true, the User ID and Password will be ignored and Integrated Security will be used.
Integrated Security = true; 在所有SQL提供程序中都不起作用，它与 OleDb 提供商。所以基本上集成安全性= SSPI; 是优选的，因为它适用于 SQLClient & OleDB 提供商。
其他选项包括：
< TBODY>
提供商
Integrated Security=true; doesn't work in all SQL providers, it throws an exception when used with the OleDb provider. So basically Integrated Security=SSPI; is preferred since works with both SQLClient & OleDB provider.
Other options are:
Provider
语法
<跨度> SqlClient
Integrated Security = true;
- 或 -
集成安全性= SSPI;
OleDb
集成安全性= SSPI;
Odbc
Trusted_Connection = yes;
OracleClient
综合安全=是;
SSPI代表安全支持提供程序接口。 SSPI允许应用程序使用系统上的任何可用安全包，而无需更改接口以使用安全服务。 SSPI不会建立登录凭据，因为这通常是操作系统处理的特权操作。
除了SSPI，您还可以使用true。
集成安全性实际上确保您使用Windows身份验证连接SQL Server，而不是SQL身份验证;这需要用连接字符串提供用户名和密码。SSPI stands for Security Support Provider Interface. The SSPI allows an application to use any of the available security packages on a system without changing the interface to use security services. The SSPI does not establish logon credentials because that is generally a privileged operation handled by the operating system.
Other than SSPI you can also use "true".
Integrated Security actually ensures that you are connecting with SQL Server using Windows Authentication, not SQL Authentication; which requires username and password to be provided with the connecting string.
这篇关于集成安全性= SSPI在连接字符串中的含义的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆