Connection string in asp.net

Question

Hi Why we write integrated security=true in connection string. Thanks in advance

Priya Linge · Answer

Hi Integrated Security -or- Trusted_Connection By default 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. Hope this will help you. Thanks.