python连接SQL SEVER问题

问题如下：

Traceback (most recent call last):
  File "src\pymssql.pyx", line 636, in pymssql.connect
  File "src\_mssql.pyx", line 1964, in _mssql.connect
  File "src\_mssql.pyx", line 682, in _mssql.MSSQLConnection.__init__
  File "src\_mssql.pyx", line 1690, in _mssql.maybe_raise_MSSQLDatabaseException
_mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:/WorkSpace/DataBase_Experiment/main.py", line 3, in <module>
    conn=pymssql.connect(host='.',database='HR',autocommit = True)
  File "src\pymssql.pyx", line 642, in pymssql.connect
pymssql.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n')

解决方案：

1. 点击此处的配置管理器。
   
2. 注意自己用的什么协议，不要选错了，然后打开对应的TCP/IP协议。
3. 重启计算机，并在connect函数中加上参数charset=‘cp936’
   例如如下代码：

conn=pymssql.connect(host='.',database='HR',autocommit = True,charset='cp936')

转载自：
https://www.cnblogs.com/springbrotherhpu/p/11503139.html