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

时间:2025/7/12 13:54:48来源：https://blog.csdn.net/m0_37886429/article/details/139231488 浏览次数:1次

一、版本说明

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.connectFile "src/pymssql/_mssql.pyx", line 2155, in pymssql._mssql.connectFile "src/pymssql/_mssql.pyx", line 712, in pymssql._mssql.MSSQLConnection.__init__File "src/pymssql/_mssql.pyx", line 1881, in pymssql._mssql.maybe_raise_MSSQLDatabaseExceptionFile "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 文件导致的，配置文件内容如下，下面配置是官网提供的示例：