ASP. Security services for integrated information about Microsoft Information Integrity, privacy, etc. integrated SECURITY=SSPI

Source: Internet
Author: User

string [email protected]"server= (local) \sqlexpress;database=adventureworks;integrated Security=sspi";
The integrated SECURITY=SSPI Security Support Provider interface in is a common API that defines a comprehensive food to validate,
Integrated security services such as Microsoft Information Integrity, information privacy, and security services for all distributed application protocols. The designer of the application protocol can take advantage of this interface to obtain different security services without having to modify the protocol itself.

-----------------------------------
Integrated Secuity identity authentication method
When False, a user ID and password are specified in the connection.
When True, the current Windows account credentials are used for authentication.
The recognized values are true,fales, yes, no, and SSPI, which is equivalent to true.
----------------------------
If you use the security authentication mechanism that comes with Windows, you can open the database without adding UID and password
If you do not write integrated SECURITY=SSPI, you must connect the string to write uid=sa;password=00;
Otherwise, you can't open the database.

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.