Integrated Security = sspi

Two Methods: User Name + Password
For example, string = "Server = localhost; database = pubs; uid = sa; Password = 11 ";
The other is to use Windows verification,
It has integrated Windows security authentication methods, such as your sspi,
Therefore, you do not need to enter the password or access the database, that is, you have the permission to access windows, that is, you have the permission to access it.
**************************************** * ***** About integrated security = sspi in SQL connection statements
Solution:
Security Support Provider Interface
When the value of integrated security is set to true, the user ID in front of the connection statement PW does not work, that is, the Windows Authentication mode is used.
The connection is based on userid and PW only when it is set to false or this item is omitted.
Integrated security can be set to: True, false, yes, no. The four values are clear and can also be set to: sspi, which is equivalent to true. We recommend that you use this instead of true. Example: <%
Dim Conn
Dim connstr
Set conn = server. Createobject ("ADODB. Connection ")
Connstr = "provider = sqloledb.1; Integrated Security = sspi; persist Security info = false; initial catalog = jiangsu_very; Data Source = (local )"
Conn. Open connstrsub closeconn ()
Conn. Close
Set conn = nothing
End sub