python连接sql提示20002错误_pymssql.operational错误：DB Lib错误消息20009，严重性9

我正试图运行这个programconn = pymssql.connect(host='localhost', user='notsa', password='notsayly', database='TallicaTweets')

但我收到以下错误：Traceback (most recent call last):

File "harvester_of_tweets.py", line 11, in

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

搜索Google并不是很有帮助，而且很少的tut也不是很彻底。是否应将凭据添加到特定配置文件中？如何在mssql中创建凭据？(我在psql中做过这些事情，但不熟悉mssql。

我正在使用Ubuntu 13.04ad我的python版本是2.7。

创建用户登录后，收到以下错误：Traceback (most recent call last):

File "harvester_of_tweets.py", line 11, in

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