python连接sql server报20002错误_如何修复pymssq中的“20002,严重级别9:自适应服务器连接失败”错误…

  • Post author:
  • Post category:python


通过SQL Server Management Studio成功连接到数据库。但是使用pymssql连接失败:

PymSql错误:pymssql.OperationalError: (17892, “Logon failed for login ‘xxx’ due to trigger exe cution.DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check mess ages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server co nnection failed (xxxx\xxxx)\n”)

版本信息:

SQL Server版本为2014 12.0.6024.0。在

Linux服务器操作系统是SUSE Linux Enterprise server 12(x86_64)。在

pymssql版本:pymssql-2.1.4

./tsql-C:Compile-time settings (established with the “configure” script)

Version: freetds v1.00.9

freetds.conf directory: /usr/local/freetds/etc

MS db-lib source compatibility: yes

Sybase binary compatibility: no

Thread safety: yes

iconv library: yes

TDS version: 7.1

iODBC: no

unixodbc: yes

SSPI



版权声明:本文为weixin_39899691原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。