title: Changing connection string from SQL Server to windows authentication
body: <p>I have to change from SQL Server authentication to Windows authentication:</p>
  
  <p>My SQL Server authentication string is:</p>
  
  <pre><code> &lt;add name="GCDataContext" 
        connectionString="Data Source=111.78.152.64;Initial Catalog=GC;User Id=sa;Password=xxxx;Trusted_Connection=False;Persist Security Info=True;MultipleActiveResultSets=True" 
        providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>Changed to (not working) </p>
  
  <pre><code> &lt;add name="GCDataContext" 
        connectionString="Data Source=111.78.152.64;Initial Catalog=GC;Persist Security Info=True;Integrated Security=True;" 
        providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>Can anyone please help me on this?</p>
  
  <p><code>Integrated Security=True</code> is for Windows authentication, but the connection is not established.</p>