what is "Integrated Security" in SQL Connection

Question

Post reply

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

g.britton SSChampion Points: 13863 More actions · Answer 1

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 · Answer 2

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.