what is "Integrated Security" in SQL Connection

• armm1388

  SSC Eights!

  Points: 808

  More actions

  December 4, 2014 at 12:03 pm

  #295652

  hi

  what is "Integrated Security" in SQL Connection?

  and it must be false or true?

  thanks

• g.britton

  SSChampion

  Points: 13863

  More actions

  December 4, 2014 at 12:07 pm

  #1762800

  see here:

  http://www.codeproject.com/Questions/194609/What-does-Integrated-Security-SSPI-means-in-the-Co

  Gerald Britton, Pluralsight courses

• t.pratiksha

  Mr or Mrs. 500

  Points: 597

  More actions

  December 8, 2014 at 6:10 am

  #1763252

  just some simpl add on:

  Default value for integrated security is false.

  When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.

  Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.

  If User ID and Password are specified and Integrated Security is set to true, the User ID and Password will be ignored and Integrated Security will be used.