title: Python - Linux - Connecting to MS SQL with Windows Credentials - FreeTDS+UnixODBC + pyodbc or pymssql
body: <p>There doesn't seem to be any great instructions for setting this up.  Does anyone have any good instructions?  I am a linux noob so be gentle.  I did see <a href="https://stackoverflow.com/questions/539430/connecting-to-ms-sql-server-using-python-on-linux-with-windows-credentials">another post</a> that is similar, but no real answer.  </p>
  
  <p>I have a couple of problems.</p>
  
  <ol>
  <li><p>FreeTDS doesn't "seem" to be working.  I am trying to connect and I get the following message using the "tsql" command: "Default database being set to databaseName
  There was a problem connecting to the server" but it doesn't mention what the problem is.</p>
  
  <ol start="2">
  <li><p>The error I get when I try to connect using pyodbc is: "pyodbc.Error: ('08S01', '[08S01] [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnectW)')"</p></li>
  <li><p>I tried something similar with pymssql, but I ran into similar issues.  I keep getting errors that I can't connect, but it doesn't tell me why.</p></li>
  </ol></li>
  </ol>