[freetds] MS SQL Protocol

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Mar 9 04:52:45 EST 2007


> 
> Hi,
> 
> I have the following questions regarding the MS SQL protocol 
> (Client-Server interaction):
> (i) What is the significance of the prelogin packet (TDS Type 0x12)?

Some informations got exchanged:
- client library version
- encryption (is not possible to have encryption without prelogin)
- instance name
- process id (just informative)
see
http://freetds.cvs.sourceforge.net/*checkout*/freetds/freetds/doc/tds_ss
l.html?revision=1.6


> (ii) If I sniff the traffic between a MS SQL Client and 
> Server, this is 
> the first packet that the Client sends on wire and has the TDS Data 
> having the string "MSSQLServer". Any reasons ?

is the default instance name.

> (iii) Also, Is it always the first packet when MS SQL is started?
> 

no, is used from TDS protocol version 8 (from mssql2k), previous do not
use this packet.

> Any inputs/refernces that answeres this questions would be 
> appreciated.
> 
> Thanks,
> Sankalp

bye
  freddy77




More information about the FreeTDS mailing list