Skip to Content.
Sympa Menu

freetds - Re: [freetds] MS SQL Protocol

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS SQL Protocol
  • Date: Fri, 9 Mar 2007 10:52:45 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page