FreeTDS Development Group

[Plot Lost <plot.lost AT gmail.com>]

I've been trying to get a SSL connection to a MS SQL 2008 server but can't
get it to work.

freetds is configured to use TDS 8, and is sending the pre-login packet
which gets the expected response. The SSL init part is then being called,
which results in the first of the negotiation packets being sent to the
server, but the connection fails.

The server is generating a error log entry of:

Encryption is required to connect to this server but the client library does
not support encryption; the connection has been closed. Please upgrade your
client library. [CLIENT: 192.168.1.50]
10/04/2010 12:00:37,Logon,Unknown,Error: 17835<c/> Severity: 20<c/> State:
1.

Anyone got any ideas as to why it does not think that freetds supports
encryption?

Extracts from the TDS logs:

Pre-Login request:
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 01 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 0c 56 00 00            -                        |.V..|
Pre-Login response:
Received header
0000 04 01 00 25 00 00 01 00-                        |...%....|
Received packet
0000 00 00 15 00 06 01 00 1b-00 01 02 00 1c 00 01 03 |........ ........|
0010 00 1d 00 00 ff 0a 32 05-48 00 00 01 00          |......2. H....|
detected flag 1

Negotiation starts:
Sending packet
0000 12 01 00 48 00 00 00 00-16 03 01 00 3b 01 00 00 |...H.... ....;...|
0010 37 03 01 4c a9 a0 fe 36-12 8a 74 bf db aa 54 cb |7..L...6 ..t...T.|
0020 bd 8b bd c1 b4 d3 73 2f-f3 64 40 9e 56 d5 2d 82 |......s/ .d@.V.-.|
0030 ef 94 2f 00 00 0a 00 09-00 03 00 06 00 12 00 ff |../..... ........|
0040 01 00 00 04 00 23 00 00-                        |.....#..|
Then it stops...
tdserror(0x9b85598, 0x9b850f0, 20017, 0)
tdserror: client library returned TDS_INT_CANCEL(2)
tdserror: returning TDS_INT_CANCEL(2)
Changed query state from IDLE to DEAD

Thanks for any help you may be able to give.