title: can't connect to SQL Server from WCF service using account
body: <p>I am trying to connect to sql server from wcf service. Using integrated security, it works fine but when I use an account, it fails. I am able to connect to sqL server management studio using this account. I am not sure what I am missing, do I need another provider to do the access. appreciate any feedback. </p>
  
  <pre><code>&lt;add name="GISDBConnectionString" connectionString="Data Source=SVRName;Initial Catalog=db;User ID=GLOBAL\Test;Password=temp"
  providerName="System.Data.SqlClient" /&gt;
  </code></pre>