Integrated Security property of connection object - ADO.NET
Q. Choose the correct option about the Integrated Security property of connection object. - Published on 16 Jun 15a. If Integrated Security=false then User ID, and Password must be specified in the connection string.
b. If Integrated Security=true then current Windows account credentials are used for authentication.
c. Both A and B option are correct.
d. None of the above.
ANSWER: Both A and B option are correct.
You can provide yes, no, true, SSPI and false value to Integrated Security property according to the requirement and security of application. If Integrated Security=false then User ID, and Password must be specified in the connection string and if true then current Windows account credentials are used for authentication.
SSPI is equivalent to specifying True.