SQL2005 encrypted connections refused

RW Salnick <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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@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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.