Re: SQL raw network connection
From: SA Developer (wimpie_at_intekom.co.za)
Date: 03/17/04
- Next message: Mike: "Detecting SQL Servers on a network"
- Previous message: Oscar: "setting up an UDL for OLEDB connection"
- In reply to: Jasper Smith: "Re: SQL raw network connection"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 14:25:35 +0200
A very big "Thank you!". This is what I've been searching for for quite
some time now.
"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:eU7J7PtCEHA.3064@tk2msftngp13.phx.gbl...
> I can tell you what your sa password is but that's about it :-)
> I don't think that TDS is documented by Microsoft but you can have a look
at
> FreeTDS http://www.freetds.org/tds.html
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
>
> "SA Developer" <wimpie@intekom.co.za> wrote in message
> news:c34846$26cs$1@newsreader02.ops.uunet.co.za...
> > Hi all
> >
> > Please find included an example of 4 packets that was captured during a
> SQL
> > client connection attempt as reference.
> > I need an explanation of the various bytes located in the packets. I
know
> > that some of them are pointers to the starting byte of various data
fields
> > located within the packet and others relate to the length of these data
> > fields.
> >
> > It would be great if I could get some type of documentation on the
> structure
> > of these packets.
> >
> > Kind regards
> >
> > Wimpie Fourie
> >
> > Captured packets
> >
> > Packet #1
> > 0x0000 12 01 00 31 00 00 00 00-00 00 15 00 06 01 00 1B
> ...1............
> > 0x0010 00 01 02 00 1C 00 09 03-00 25 00 04 FF 08 00 01
> .........%..ÿ...
> > 0x0020 55 00 00 00 56 53 64 6F-74 4E 45 54 00 34 29 00
> U...VSdotNET.4).
> > 0x0030 00 .
> >
> > Packet #2
> > 0x0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1B
> ...%............
> > 0x0010 00 01 02 00 1C 00 01 03-00 1D 00 00 FF 08 00 01
> ............ÿ...
> > 0x0020 7E 00 00 02 00 ~....
> >
> > Packet #3
> > 0x0000 10 01 01 20 00 00 01 00-18 01 00 00 01 00 00 71 ...
> ...........q
> > 0x0010 00 00 00 00 00 00 00 07-C8 28 00 00 00 00 00 00
> ........È(......
> > 0x0020 E0 03 00 00 88 FF FF FF-09 1C 00 00 56 00 08 00
> à...^ÿÿÿ....V...
> > 0x0030 66 00 02 00 6A 00 0A 00-7E 00 2E 00 DA 00 11 00
> f...j...~...Ú...
> > 0x0040 00 00 00 00 FC 00 04 00-04 01 00 00 04 01 0A 00
> ....ü...........
> > 0x0050 00 10 4B 30 44 7D 00 00-00 00 18 01 00 00 5A 00
> ..K0D}........Z.
> > 0x0060 41 00 56 00 43 00 30 00-31 00 30 00 31 00 73 00
> A.V.C.0.1.0.1.s.
> > 0x0070 61 00 B6 A5 D2 A5 B6 A5-63 A5 63 A5 D3 A5 96 A5
> a.¶¥Ò¥¶¥c¥c¥Ó¥-¥
> > 0x0080 E2 A5 B6 A5 43 A5 4D 00-69 00 63 00 72 00 6F 00
> ⥶¥C¥M.i.c.r.o.
> > 0x0090 73 00 6F 00 66 00 74 00-28 00 52 00 29 00 20 00
s.o.f.t.(.R.).
> .
> > 0x00A0 57 00 69 00 6E 00 64 00-6F 00 77 00 73 00 20 00
W.i.n.d.o.w.s.
> .
> > 0x00B0 28 00 52 00 29 00 20 00-32 00 30 00 30 00 30 00 (.R.).
> .2.0.0.0.
> > 0x00C0 20 00 4F 00 70 00 65 00-72 00 61 00 74 00 69 00
> .O.p.e.r.a.t.i.
> > 0x00D0 6E 00 67 00 20 00 53 00-79 00 73 00 74 00 65 00 n.g.
> .S.y.s.t.e.
> > 0x00E0 6D 00 5A 00 41 00 56 00-43 00 30 00 31 00 39 00
> m.Z.A.V.C.0.1.9.
> > 0x00F0 38 00 5C 00 56 00 53 00-64 00 6F 00 74 00 4E 00
> 8.\.V.S.d.o.t.N.
> > 0x0100 45 00 54 00 4F 00 44 00-42 00 43 00 49 00 73 00
> E.T.O.D.B.C.I.s.
> > 0x0110 49 00 74 00 53 00 74 00-6F 00 6C 00 65 00 6E 00
> I.t.S.t.o.l.e.n.
> >
> > Packet #4
> > 0x0000 04 01 01 AD 00 33 01 00-E3 23 00 01 0A 49 00 73
> ....3..ã#...I.s
> > 0x0010 00 49 00 74 00 53 00 74-00 6F 00 6C 00 65 00 6E
> .I.t.S.t.o.l.e.n
> > 0x0020 00 06 6D 00 61 00 73 00-74 00 65 00 72 00 AB 80
> ..m.a.s.t.e.r.«?
> > 0x0030 00 45 16 00 00 02 00 29-00 43 00 68 00 61 00 6E
> .E.....).C.h.a.n
> > 0x0040 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 .g.e.d.
> .d.a.t.a
> > 0x0050 00 62 00 61 00 73 00 65-00 20 00 63 00 6F 00 6E .b.a.s.e.
> .c.o.n
> > 0x0060 00 74 00 65 00 78 00 74-00 20 00 74 00 6F 00 20 .t.e.x.t.
.t.o.
> > 0x0070 00 27 00 49 00 73 00 49-00 74 00 53 00 74 00 6F
> .'.I.s.I.t.S.t.o
> > 0x0080 00 6C 00 65 00 6E 00 27-00 2E 00 11 5A 00 41 00
> .l.e.n.'....Z.A.
> > 0x0090 56 00 43 00 30 00 31 00-39 00 38 00 5C 00 56 00
> V.C.0.1.9.8.\.V.
> > 0x00A0 53 00 44 00 4F 00 54 00-4E 00 45 00 54 00 00 00
> S.D.O.T.N.E.T...
> > 0x00B0 00 E3 08 00 07 05 09 04-D0 00 34 00 E3 17 00 02
> .ã......Ð.4.ã...
> > 0x00C0 0A 75 00 73 00 5F 00 65-00 6E 00 67 00 6C 00 69
> .u.s._.e.n.g.l.i
> > 0x00D0 00 73 00 68 00 00 AB 7C-00 47 16 00 00 01 00 27
> .s.h..«|.G.....'
> > 0x00E0 00 43 00 68 00 61 00 6E-00 67 00 65 00 64 00 20
.C.h.a.n.g.e.d.
> > 0x00F0 00 6C 00 61 00 6E 00 67-00 75 00 61 00 67 00 65
> .l.a.n.g.u.a.g.e
> > 0x0100 00 20 00 73 00 65 00 74-00 74 00 69 00 6E 00 67 .
> .s.e.t.t.i.n.g
> > 0x0110 00 20 00 74 00 6F 00 20-00 75 00 73 00 5F 00 65 . .t.o.
> .u.s._.e
> > 0x0120 00 6E 00 67 00 6C 00 69-00 73 00 68 00 2E 00 11
> .n.g.l.i.s.h....
> > 0x0130 5A 00 41 00 56 00 43 00-30 00 31 00 39 00 38 00
> Z.A.V.C.0.1.9.8.
> > 0x0140 5C 00 56 00 53 00 44 00-4F 00 54 00 4E 00 45 00
> \.V.S.D.O.T.N.E.
> > 0x0150 54 00 00 00 00 AD 36 00-01 71 00 00 01 16 4D 00
> T....6..q....M.
> > 0x0160 69 00 63 00 72 00 6F 00-73 00 6F 00 66 00 74 00
> i.c.r.o.s.o.f.t.
> > 0x0170 20 00 53 00 51 00 4C 00-20 00 53 00 65 00 72 00 .S.Q.L.
> .S.e.r.
> > 0x0180 76 00 65 00 72 00 00 00-00 00 08 00 01 80 E3 13
> v.e.r........?ã.
> > 0x0190 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00
> ...4.0.9.6..4.0.
> > 0x01A0 39 00 36 00 FD 00 00 00-00 00 00 00 00 9.6.ý........
> >
> >
>
>
- Next message: Mike: "Detecting SQL Servers on a network"
- Previous message: Oscar: "setting up an UDL for OLEDB connection"
- In reply to: Jasper Smith: "Re: SQL raw network connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
