Skip to Content.
Sympa Menu

freetds - Protocol discovery

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "Freetds (E-mail)" <freetds AT franklin.metalab.unc.edu>
  • Subject: Protocol discovery
  • Date: Tue, 17 Sep 2002 16:12:59 +0200


I'm trying to see how windows discovery the protocol of server.
I tried first with oldest server (6.5) and seem quite strange

Packet to server (MSSQL2K reply to this directly)
00000000 12 01 00 34 00 00 00 00 00 00 15 00 06 01 00 1b ...4.... ........
00000010 00 01 02 00 1c 00 0c 03 00 28 00 04 ff 08 00 00 ........ .(......
00000020 c2 00 00 00 4d 53 53 51 4c 53 65 72 76 65 72 00 ....MSSQ LServer.
00000030 e8 06 00 00 ....


Packet from server (MSSQL6.5)
00000000 04 01 00 43 00 14 00 00 aa 00 00 00 2f 0f a2 01 ...C.... ..../...
00000010 0e 00 17 20 4c 6f 67 69 6e 20 66 61 69 6c 65 64 ... Logi n failed
00000020 0d 0a 14 4d 69 63 72 6f 73 6f 66 74 20 53 51 4c ...Micro soft SQL
00000030 20 53 65 72 76 65 72 00 00 00 fd 00 fd 00 00 00 Server. ........
00000040 00 00 02 ...

This seem a standard packet but first token (TDS_ERROR) seem a bit
different..
aa TDS_ERROR
00 00 should be length.. why 0 ??
00 ??
2f this is real length
0f length of message (not in from of message...)
a2 01 this is code error (big endian)
0e error level
00 17 ??
message (start with space even in sysmessages)
14 length of server type ?
server type (Microsoft SQL Server)
00 00 00 fd 00 ???

Also windows cache in registry version of tds (like "7.0" or "4.2" and try
directly this... (I hope if response is different close connection..)

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================



  • Protocol discovery, ZIGLIO Frediano, 09/17/2002

Archive powered by MHonArc 2.6.24.

Top of Page