Connection string’s pair for using WindowsAuthentication - ADO.NET

Q.  What is the connection string’s key / value pair for using WindowsAuthentication in SQLServer 2000 and SQL Server 2005?
- Published on 19 Oct 15

a. 1, 2
b. 1, 2, 3
c. 2, 3
d. 1, 4

ANSWER: 2, 3
You can provide yes, no, true, SSPI and false value to Integrated Security property of connection string according to the requirement. If Integrated Security= truethen 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.)