通过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 "trusted" logins: no
Kerberos: no
OpenSSL: yes
GnuTLS: no
MARS: no
更多freetds.log文件
^{pr2}$
乙酰胆碱酯酶3
LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=C;LC_COLLATE=C;LC_MONETARY=C;LC_MESSAGES=C;LC_PAPER= C;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=C;LC_IDENTIFICATION=C" locale charset is "UTF-8" using default charset "UTF-8" Msg 18456 (severity 14, state 1) from xxxx\xxxxx Line 1: "Login failed for user 'xxxx'.
我该怎么解决这个问题