[freetds] SQL2005 encrypted connections refused

RW Salnick bob at salnick.cac.washington.edu
Tue Mar 4 16:02:07 EST 2008


Using 0.64 or 0.82RC1, I cannot successfully make a connection to a 
SQL2005 server when that server has 'Force Encryption' turned on.  Am I 
doing something wrong, or is this an unsupported function?  (FWIW, I 
_can_ make a connection to a SQL2000 server that server has 'Force 
Encryption' turned on. )

Here is what the log shows when I make the attempt:

locale is "en_US.iso885915"
locale charset is "ISO-8859-15"
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server
[salnick at salnick freetds-0.82RC1]$ cat freetds.log
log.c:190:Starting log file for FreeTDS 0.82RC1
        on 2008-03-04 13:01:00 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-15" 
character set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-15"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:192:Connecting to 172.22.7.12 port 3585 (TDS version 7.0)
net.c:248:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:288:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
util.c:334:tdserror(0x8104df0, 0x81071d8, 20017, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:316:looking for login token, got  0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(0x8104df0, 0x81071d8, 20002, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:563:tds_free_all_results()


bob



More information about the FreeTDS mailing list