title: SQL Server 2008: ODBC connection problems
body: <p>I am able to successfully connect from access 2007 into SQL Server 2008 using ODBC; however it prompts me with the password each time.</p>
  
  <p>When I try to open the linked table from access it says connection filed: <code>SQLSTATE '28000' SQL SERVER ERROR 18452 [microsoft][odbc.........[][]] login failed. the loin is frmo an untrusted domain and cannot be used with windows authentication.</code> </p>
  
  <p>However I am NOT using win authentication, I'm using SQL Server authentication</p>
  
  <p>After this error, I get a prompt for SQL Server login where I enter credentials and then it works fine</p>
  
  <p>here's my connection string:</p>
  
  <pre><code>[ODBC]
  Driver=SQL Server
  Uid=myuser
  Pwd=mypass
  App=2007 microsoft office system
  server=servername
  </code></pre>
  
  <p>Is there something I can adjust with my connection string to force it to connect with SQL Server authentication instead of windows auth?</p>