title: pyodbc- connection failure to SQL Server
body: <p>I have been trying to connect to Microsoft SQL Server. I have an ODBC connection set up and the test is successful. I am not using Windows Authentication to connect to SQL Server but it keep getting this error: </p>
  
  <blockquote>
    <p>Cannot be used with Windows authentication</p>
    
    <p>InterfaceError: ('28000', '[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (18452) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (18452); [28000] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)')</p>
  </blockquote>
  
  <p>Here is my code:</p>
  
  <pre><code>import pyodbc
  cnxn = pyodbc.connect(Driver='{SQL Server}',
                        Server='servername.abc.xyz.co.com',
                        username = 'user_xyz', 
                        password = 'abcdfgh')
  </code></pre>
  
  <p>I am using Windows 7. Please help me debug this problem</p>
  
  <p>Thanks</p>