Menu
I have two apps that use Integrated Security. One assigns Integrated Security = true in the connection string, and the other sets Integrated Security = SSPI.
What is the difference between SSPI and true in the context of Integrated Security?
357
Integrated Security=SSPI" 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.
A trusted connection is used if you're connecting to the database without providing a user name and password. For example, if you are connecting via a Data Source Name, and the DSN contains the user ID you're using to connect, then your trusted connection is true.
Integrated security systems are a type of multi-layered system that uses different components and threads them into one. At Sonitrol, we utilize a layered system consisting of audio-based intrusion detection, alarm notifications, a 24/7 staff, commercial access control, fire and smoke detection, and video monitoring.
Integrated security uses the current Windows identity established on the operating system thread to access the SQL Server database. You can then map the Windows identity to a SQL Server database and permissions.
According to Microsoft they are the same thing.
When
false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
Recognized values aretrue,false,yes,no, andsspi(strongly recommended), which is equivalent totrue.
141
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
