title: pymssql.OperationalError: DB-Lib error message 20009, severity 9
body: <p>I am trying to run this <a href="http://ryrobes.com/python/harvesting-twitter-search-results-for-analysis-using-python-sql-server/" rel="noreferrer">program</a></p>
  
  <pre><code>conn = pymssql.connect(host='localhost',  user='notsa', password='notsayly', database='TallicaTweets')
  </code></pre>
  
  <p>but I am receiving the following errors:</p>
  
  <pre><code>Traceback (most recent call last):
    File "harvester_of_tweets.py", line 11, in &lt;module&gt;
      conn = pymssql.connect(host='localhost',  user='username', password='password!', database='Database')
    File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
      raise OperationalError, e[0]
  pymssql.OperationalError: DB-Lib error message 20009, severity 9:
  Unable to connect: Adaptive Server is unavailable or does not exist
  Net-Lib error during Connection refused Error 111 - Connection refused
  </code></pre>
  
  <p>Searching Google wasn't really helpful and the few tuts out there weren't really thorough. Should I add my credential into a specific configuration file? And how to create credentials in mssql? (I have done these things in psql but not familiar with mssql.</p>
  
  <p>I am using Ubuntu 13.04 ad my python version is 2.7.</p>
  
  <p>After I created a user login I am receiving this error:</p>
  
  <pre><code>Traceback (most recent call last):
    File "harvester_of_tweets.py", line 11, in &lt;module&gt;
      conn = pymssql.connect(host='localhost',  user='tweet', password='1234', database='tweet_db')
    File "/usr/local/lib/python2.7/dist-packages/pymssql.py", line 607, in connect
      raise OperationalError, e[0]
  pymssql.OperationalError: DB-Lib error message 20009, severity 9:
  Unable to connect: Adaptive Server is unavailable or does not exist
  Net-Lib error during Connection refused Error 111 - Connection refused
  </code></pre>