FreeTDS Development Group

["Fernando" <nulll AT bol.com.br>]

> > > 
> > > Perhaps server is requiring authentication. What type of server is ?
> > > 
> > > freddy77
> > 
> > My server is MS SQL Server 7.0 in Win2000
> > And because I receive this packet anytimes ? In other times i 
> > receive the
> > packet 0xFD and finish, i'm logged. What I have send to server when i
> > receive this 0xED ?
> > 
> > Regards !
> > 
> Perhaps you change password and server require another login ?
> Can you capture transmission? Use "port 1433" filter with tcpdump or
> ethereal or enable log on freetds and send it.
> Or use netmon on windows (never used)...
> 
> freddy77

   Where I get(download) this netmon ?? I don't use freetds, I'm writing
one small application, in Delphi, to understand the TDS protocol. Maybe I
write one dbExpress driver to Delphi/Kylix over TDS. Actually i try codify
the login whith NT authentication. I'm with the following problems:
[>>Send //// <<Receive]

1) 
>>10010093000001008B0000000000007100000000000000071403000000000000E0830000B40000001604000056000000560000005600000056000700640006000000000070000A0084000000840000008B1D790DFCB05B0030008B0000004100700070004E0061006D006500760074007300310030003000440042002D004C006900620072006100720079004E544C4D535350

<<0401000B00000000ED0000

2)
>>10010093000001008B00000000000071000000000000000682F2F8FF00000000E003000088FFFFFF3604000056000000560000005600000056000700640006000000000070000A0084000000840000008B1D790DFCB05B0030008B0000004100700070004E0061006D006500760074007300310030003000440042002D004C006900620072006100720079004E544C4D535350

<<040100D800000000AAC40014480000010E5C004C006F00670069006E0020006600610069006C0065006400200066006F007200200075007300650072002000270028006E0075006C006C00290027002E00200052006500610073006F006E003A0020004E006F00740020006100730073006F006300690061007400650064002000770069007400680020006100200074007200750073007400650064002000530051004C002000530065007200760065007200200063006F006E006E0065006300740069006F006E002E0000000000FD0200000000000000

3)
>>100100A3000001009B00000000000071000000000000000682F2F8FF00000000E003000088FFFFFF3604000056000000000000000000000056000700640006000000000070000A0084000000840000008B1D790DFCB06B0030009B0000004100700070004E0061006D006500760074007300310030003000440042002D004C006900620072006100720079004E544C4D535350000100000007B200A007000700290000000900090020000000534154454C4C495445444F4DCD4E494F

<<040100D800000000AAC40014480000010E5C004C006F00670069006E0020006600610069006C0065006400200066006F007200200075007300650072002000270028006E0075006C006C00290027002E00200052006500610073006F006E003A0020004E006F00740020006100730073006F006300690061007400650064002000770069007400680020006100200074007200750073007400650064002000530051004C002000530065007200760065007200200063006F006E006E0065006300740069006F006E002E0000000000FD0200000000000000

4)
>>100100A3000001009B0000000000007100000000000000071403000000000000E0830000B40000001604000056000000000000000000000056000700640006000000000070000A0084000000840000008B1D790DFCB06B0030009B0000004100700070004E0061006D006500760074007300310030003000440042002D004C006900620072006100720079004E544C4D535350000100000007B200A007000700290000000900090020000000534154454C4C495445444F4DCD4E494F

<<0401000B00000000ED0000

5) [I'm capture the login packet of Query Analyser and I send it of my
app.]
>>100100D200000100CA0000000100007100000000000000071403000000000000E0830000B400000016040000560000000000000000000000560015008000090000000000920004009A0000009A0000008B1D790DFCB09A003000CA0000004D0053002000530051004C00200051007500650072007900200041006E0061006C0079007A006500720053006100740065006C006C006900740065004F004400420043004E544C4D535350000100000007B200A007000700290000000900090020000000534154454C4C495445444F4DD64E494F

<<0401008B00000000ED80004E544C4D53535000020000000E000E003000000005C281A07473A0A871C6AE2FF804090000000000420042003E00000044004F004D00CD004E0049004F0002000E0044004F004D00CD004E0049004F000100120053004100540045004C004C004900540045000300120053006100740065006C006C0069007400650000000000

 
I try many ways ...

Regards!