Python3 使用 pymssql 连接 SQL Server 报错：DB-Lib error message 20002, severity 9

一、版本说明

python版本：  3.12.1
pymssql版本：  2.3.0        # pymssql.version_info()
SQL Server版本：SQL Server 2008
OS版本： rocky linux 9.4

二、报错信息

Traceback (most recent call last):
  File "src/pymssql/_pymssql.pyx", line 650, in pymssql._pymssql.connect
  File "src/pymssql/_mssql.pyx", line 2155, in pymssql._mssql.connect
  File "src/pymssql/_mssql.pyx", line 712, in pymssql._mssql.MSSQLConnection.__init__
  File "src/pymssql/_mssql.pyx", line 1881, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
  File "src/pymssql/_mssql.pyx", line 1898, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.16.250)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.16.250)\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "src/pymssql/_pymssql.pyx", line 659, in pymssql._pymssql.connect
pymssql.exceptions.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.16.250)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (192.168.16.250)\n')

三、排查

通过python自带的os模块，详细打印连接详细日志 os.environ['TDSDUMP'] = 'stdout'

从报错信息上可以发现，是找不到 /root/.freetds.conf 或者 /usr/local/etc/freetds.conf 文件导致的，配置文件内容如下，下面配置是官网提供的示例：

[global]
    port = 1433
    tds version = 7.0

详情可以查看官网，地址是：https://www.pymssql.org/freetds.html

四、解决

添加上官网的配置

重新连接，没有报错，执行SQL，有数据输出