[freetds] SQL2005 encrypted connections refused
Bob Hetzel
beh at case.edu
Tue Mar 4 16:45:43 EST 2008
I couldn't get it to work properly with openssl, struggling for quite
some time. Somebody else on the list mentioned that he had success with
using gnutls. That also fixed my problem.
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 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list