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:59:14 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page