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 15

a. 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.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)