stackoverflow 上面查了下，有这个例子，我把 password 改成 passwd 也报错！
把链接字符串拼接成一个字符串传入也不对
print 'host=',SQLSERVER,"user=",USER,"password=",PASSWORD,"database=",DATABASE
g_Conn = pymssql.connect(host=SQLSERVER,user=USER,password=PASSWORD,database=DATABASE)
输出正常值，在初始化连接的时候报错

@staticmethod
def connect():
servers = ["server1", "server2", "server3"]
conn = None
for server in servers:
try:
conn = pymssql.connect(server, settings.MSSQL_USERNAME, settings.MSSQL_PASSWORD, settings.MSSQL_DB_NAME, charset="ISO-8859-1")
break
except:
logger.info("Failed to connect to MSSQL Server: " + server)

if conn:
return conn
else:
logger.info("Failed to connect to ALL MSSQL servers")
return conn




结果多次测试已经算是解决了吧
配置文件读取后显式的调用下可以使用了

cf=ConfigParser.ConfigParser()
cf.read("conf.ini")
DATABASE=cf.get("app_info","DATABASE")
USER=cf.get("app_info","USER")
PASSWORD=cf.get("app_info","PASSWORD")
HOST=cf.get("app_info","HOST")
PORT=cf.get("app_info","PORT")
#HOST = '127.0.0.1'
USER = 'test'
PASSWORD = 'test'
#DATABASE = 'test'
PORT='1433'
HOST1 = '127.0.0.1'
USER1 = 'test'
PASSWORD1 = 'test'
#DATABASE1 = 'test'
PORT1=PORT
HOST1 = HOST
USER1 = USER
PASSWORD1 =PASSWORD
DATABASE1 = DATABASE
PORT1=PORT



conn=pymssql.connect(host=HOST1,user=USER1,password=PASSWORD1,database=DATABASE1,port=PORT1)