服务器 Gind.cn
  1. 服务器 Gind.cn
  3. 使用FreeTDS连接到MS SQL Server：错误20002：“Adaptive Server连接失败”
Intereting Posts
如果木偶项目中存在单独的文件资源，则文件资源不应跳过文件 更改pam.d / system_auth？ 打开SCVMMpipe理控制台时出现错误的图像错误 在linux的后台运行python应用程序 与mamp的Python 如何保护在共享桌面上运行的Windows应用程序？ 在Linux上configurationBazaar存储库 以零停机时间移动SQL Server数据库 主板上的SATA电源连接器是否兼容2.5和3.5驱动器？ 数据库安全 将外部域configuration为Openshift CentOS 6.2 – 我无法使用Alt + Ctrl + F2（F1到F6）访问控制台 Exchange Server 2007邮件跟踪日志调整？ IPv6前缀pipe理 SVN + SSH安全

使用FreeTDS连接到MS SQL Server：错误20002：“Adaptive Server连接失败”

我尝试使用FreeTDS从Linux服务器（RHEL v7）连接到运行MS SQL Server 2014的单独服务器。但是，尝试连接tsql时，出现以下错误（错误消息根据是否包含用户名和密码）： 

$ tsql -S MYSERVER locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" Error 20002 (severity 9): Adaptive Server connection failed There was a problem connecting to the server $ tsql -S MYSERVER -U myusername -P mypassword locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" Error 20017 (severity 9): Unexpected EOF from the server Error 20002 (severity 9): Adaptive Server connection failed There was a problem connecting to the server

另外，运行tsql -LH不会输出： 

 $ tsql -LH MYSERVER $

我不相信这个问题是与SQL Server端的防火墙或其他任何东西，因为：

  1. 我能够telnet到服务器： 

     $ telnet my.server.address 1433 Trying 11.22.33.444... Connected to my.server.address.
  2. 而且，我可以通过ODBC（Windows）笔记本电脑通过ODBC数据源pipe理器实用程序成功连接到SQL Server。

我的/etc/freetds.conf的内容： 

 [global] tds version = 7.0 ; tds version = 4.2 ... [MYSERVER] host = my.server.address port = 1433 tds version = 7.0

运行tsql后的TDSDUMP日志文件的内容-S MYSERVER： 

 log.c:167:Starting log file for FreeTDS 0.95.19 on 2015-11-18 10:02:20 with debug flags 0x4fff. iconv.c:328:tds_iconv_open(0x1c53d90, UTF-8) iconv.c:187:local name for ISO-8859-1 is ISO-8859-1 iconv.c:187:local name for UTF-8 is UTF-8 iconv.c:187:local name for UCS-2LE is UCS-2LE iconv.c:187:local name for UCS-2BE is UCS-2BE iconv.c:346:setting up conversions for client charset "UTF-8" iconv.c:348:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion iconv.c:395:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion iconv.c:400:tds_iconv_open: done net.c:202:Connecting to 11.22.33.444 port 1433 (TDS version 7.0) net.c:274:tds_open_socket: connect(2) returned "Operation now in progress" net.c:313:tds_open_socket() succeeded util.c:165:Changed query state from DEAD to IDLE login.c:797:using GSS authentication gssapi.c:218:using kerberos name MSSQLSvc/my.server.address:1433 gssapi.c:230:gss_import_name: GSS_S_COMPLETE: gss_import_name completed successfully. gssapi.c:318:gss_init_sec_context: actual mechanism at 0x(nil) gssapi.c:334:gss_init_sec_context: min_stat 2529639136 "Unknown error -1765328160" gssapi.c:374:gss_init_sec_context: GSS_S_FAILURE: The routine failed for reasons that are not defined at the GSS level. login.c:472:login packet rejected query.c:3769:tds_disconnect() util.c:165:Changed query state from IDLE to DEAD util.c:322:tdserror(0x1c53ca0, 0x1c53d90, 20002, 0) util.c:352:tdserror: client library returned TDS_INT_CANCEL(2) util.c:375:tdserror: returning TDS_INT_CANCEL(2) mem.c:648:tds_free_all_results()