通过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