How to make a connection string using windows authentication?

Question

I am working on a website, where I use windows authentication in the database.

I suppose that you use the following for SQL authentication:

<connectionStrings> 

    <add name="NorthwindContex" 

       connectionString="data source=localhost;

       initial catalog=northwind;persist security info=True; 

       user id=sa;password=P@ssw0rd" 

       providerName="System.Data.SqlClient" /> 

</connectionStrings>

What is the way to modify this to work with windows authentication?

Answer 1

In SQL, It is very easy to establish a connection string. 

Actually, you need to replace the username and password with Integrated Security=SSPI;

Therefore the connection string should be:

<connectionStrings> 

<add name="NorthwindContex" 

   connectionString="data source=localhost;

   initial catalog=northwind;persist security info=True; 

   Integrated Security=SSPI;" 

   providerName="System.Data.SqlClient" /> 

</connectionStrings>