FreeTDS Development Group

[Bob Hetzel <beh AT case.edu>]

Looking through old postings on the list it appears you may need to 
specify protocol version 8.0 and you need to use the freetds.conf option 
of either

encryption = request
or
encryption = required

I just noted that this isn't in the docs on freetds.org

   Bob


RW Salnick wrote:
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds