Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL2005 encrypted connections refused

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Hetzel <beh AT case.edu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL2005 encrypted connections refused
  • Date: Tue, 04 Mar 2008 16:45:43 -0500

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@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




Archive powered by MHonArc 2.6.24.

Top of Page