Home Library Learn Samples Downloads Support Community Forums
Microsoft Developer Network >
> 
> 
SQL Server connection issues using TDS 7.3 and .NET

Unanswered SQL Server connection issues using TDS 7.3 and .NET

  • 27 martie 2012 18:40
     
     
    Sign in pentru a vota
    0

    I am with some of my users. The .NET app will connect 95% of the time without issues to my sql server 2005.

    I have set up NetMon as a packet sniffer and can see the packets getting to the SQL server. In the successful attempts I see TDS version 7.2 which matches SQL 2005. In failed attempts I see (Tds: Prelogin, Version = 7.300000 (No version information available, using the default version).

    Any idea why these would be connecting using 7.3,  this should only be used for SQL 2008 I believe. 

    How does an application know which version to use?

    Thanks,

    Mike

     

Toate mesajele

  • 28 martie 2012 03:19
    Moderator
     
     
    Sign in pentru a vota
    1

    Hi Mike,

    As you known, TDS version 7.3 is for SQL Server 2008. Since you can see the ‘Process Name’ and ‘Destination’ from the Network Monitor, you can find the application running on that client. Please check if there is any SQL Server Alias in that client which redirect to the connection to SQL Server 2008 instance. If that does not the case, please try to delete the last connection information from registry on the client: HKLM\Software\Microsoft\MSSQLServer\Client.

    In addition, you can use TCP/IP protocol with server name and port number on your connection string to connect the target SQL Server instance directly.

    TechNet Subscriber Support
    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    Stephanie Lv

    TechNet Community Support

     
  • 28 martie 2012 13:06
     
     
    Sign in pentru a vota
    0

    There does not seem to be any server alias.

    Can anybody tell me how the application determines what tds version to use for the prelogin.

    Here is some additional information from the dbmon trace.  Specifically line 17304 where the application sends the wrong tds version is where the app fails.

    Failed Session:

    17301 4:23:17 PM 3/21/2012 1814.3444957 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=......S., SrcPort=56246, DstPort=1433, PayloadLen=0, Seq=126092483, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192 {TCP:679, IPv4:35}
    17302 4:23:17 PM 3/21/2012 1814.3446760 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A..S., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830508, Ack=126092484, Win=64240 ( Negotiated scale factor 0x0 ) = 64240 {TCP:679, IPv4:35}
    17303 4:23:17 PM 3/21/2012 1814.3446969 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56246, DstPort=1433, PayloadLen=0, Seq=126092484, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17304 4:23:17 PM 3/21/2012 1814.3450322 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TDS TDS:Prelogin, Version = 7.300000(No version information available, using the default version), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56246, DstPort=1433, PayloadLen=47, Seq=126092484 - 126092531, Ack=2574830509, Win=65536 {TDS:680, TCP:679, IPv4:35}
    17310 4:23:17 PM 3/21/2012 1814.5473148 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830509, Ack=126092531, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17350 4:23:32 PM 3/21/2012 1829.3411547 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...F, SrcPort=56246, DstPort=1433, PayloadLen=0, Seq=126092531, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17351 4:23:32 PM 3/21/2012 1829.3413104 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830509, Ack=126092532, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17502 4:24:02 PM 3/21/2012 1859.3551578 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Segment Lost]Flags=...A...., SrcPort=56246, DstPort=1433, PayloadLen=1, Seq=126092531 - 126092532, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17503 4:24:02 PM 3/21/2012 1859.3553354 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Dup Ack #17351]Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830509, Ack=126092532, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17510 4:24:02 PM 3/21/2012 1859.5096117 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Segment Lost]Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=1, Seq=2574830508 - 2574830509, Ack=126092532, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17511 4:24:02 PM 3/21/2012 1859.5096217 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56246, DstPort=1433, PayloadLen=0, Seq=126092532, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17633 4:24:32 PM 3/21/2012 1889.3695647 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[ReTransmit #17502]Flags=...A...., SrcPort=56246, DstPort=1433, PayloadLen=1, Seq=126092531 - 126092532, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17634 4:24:32 PM 3/21/2012 1889.3701087 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Dup Ack #17351]Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830509, Ack=126092532, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17640 4:24:32 PM 3/21/2012 1889.5857530 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[ReTransmit #17510]Flags=...A...., SrcPort=1433, DstPort=56246, PayloadLen=1, Seq=2574830508 - 2574830509, Ack=126092532, Win=64193 (scale factor 0x0) = 64193 {TCP:679, IPv4:35}
    17641 4:24:32 PM 3/21/2012 1889.5857622 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Dup Ack #17511]Flags=...A...., SrcPort=56246, DstPort=1433, PayloadLen=0, Seq=126092532, Ack=2574830509, Win=256 (scale factor 0x8) = 65536 {TCP:679, IPv4:35}
    17740 4:24:57 PM 3/21/2012 1915.2723721 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A.R.., SrcPort=1433, DstPort=56246, PayloadLen=0, Seq=2574830509, Ack=126092532, Win=0 (scale factor 0x0) = 0 {TCP:679, IPv4:35}

    Working Session:

    17259 4:23:16 PM 3/21/2012 1813.9734517 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=......S., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125041766, Ack=0, Win=8192 ( Negotiating scale factor 0x8 ) = 8192 {TCP:675, IPv4:35}
    17260 4:23:16 PM 3/21/2012 1813.9736238 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A..S., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248727534, Ack=2125041767, Win=64240 ( Negotiated scale factor 0x0 ) = 64240 {TCP:675, IPv4:35}
    17261 4:23:16 PM 3/21/2012 1813.9736471 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125041767, Ack=1248727535, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17262 4:23:16 PM 3/21/2012 1813.9740502 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TDS TDS:Prelogin, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56245, DstPort=1433, PayloadLen=47, Seq=2125041767 - 2125041814, Ack=1248727535, Win=65536 {TDS:676, TCP:675, IPv4:35}
    17263 4:23:16 PM 3/21/2012 1813.9743167 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=43, Seq=1248727535 - 1248727578, Ack=2125041814, Win=64193 {TDS:676, TCP:675, IPv4:35}
    17264 4:23:16 PM 3/21/2012 1813.9744721 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TLS TLS:TLS Rec Layer-1 HandShake: Client Hello. {TLS:678, SSLVersionSelector:677, TDS:676, TCP:675, IPv4:35}
    17265 4:23:16 PM 3/21/2012 1813.9750008 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TLS TLS:TLS Rec Layer-1 HandShake: Server Hello.; TLS Rec Layer-2 Cipher Change Spec; TLS Rec Layer-3 HandShake: Encrypted Handshake Message. {TLS:678, SSLVersionSelector:677, TDS:676, TCP:675, IPv4:35}
    17266 4:23:16 PM 3/21/2012 1813.9751784 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TLS TLS:TLS Rec Layer-1 Cipher Change Spec; TLS Rec Layer-2 HandShake: Encrypted Handshake Message. {TLS:678, SSLVersionSelector:677, TDS:676, TCP:675, IPv4:35}
    17267 4:23:16 PM 3/21/2012 1813.9794838 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TLS TLS:TLS Rec Layer-1 SSL Application Data {TLS:678, SSLVersionSelector:677, TDS:676, TCP:675, IPv4:35}
    17268 4:23:16 PM 3/21/2012 1813.9796939 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248727715, Ack=2125042468, Win=63539 (scale factor 0x0) = 63539 {TCP:675, IPv4:35}
    17269 4:23:16 PM 3/21/2012 1813.9799440 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=34, Seq=1248727715 - 1248727749, Ack=2125042468, Win=63539 {TDS:676, TCP:675, IPv4:35}
    17270 4:23:16 PM 3/21/2012 1813.9800775 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TDS TDS:SSPIMessage, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56245, DstPort=1433, PayloadLen=61, Seq=2125042468 - 2125042529, Ack=1248727749, Win=65280 {TDS:676, TCP:675, IPv4:35}
    17271 4:23:16 PM 3/21/2012 1813.9804149 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=260, Seq=1248727749 - 1248728009, Ack=2125042529, Win=63478 {TDS:676, TCP:675, IPv4:35}
    17272 4:23:16 PM 3/21/2012 1813.9805884 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TDS TDS:SSPIMessage, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56245, DstPort=1433, PayloadLen=560, Seq=2125042529 - 2125043089, Ack=1248728009, Win=65024 {TDS:676, TCP:675, IPv4:35}
    17273 4:23:16 PM 3/21/2012 1813.9825973 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=20, Seq=1248728009 - 1248728029, Ack=2125043089, Win=62918 {TDS:676, TCP:675, IPv4:35}
    17274 4:23:16 PM 3/21/2012 1813.9838282 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 66, PacketID = 1, Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=397, Seq=1248728029 - 1248728426, Ack=2125043089, Win=62918 {TDS:676, TCP:675, IPv4:35}
    17275 4:23:16 PM 3/21/2012 1813.9838374 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043089, Ack=1248728426, Win=253 (scale factor 0x8) = 64768 {TCP:675, IPv4:35}
    17276 4:23:16 PM 3/21/2012 1813.9839404 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TDS TDS:RPCRequest, Version = 7.2 (0x72090002), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56245, DstPort=1433, PayloadLen=122, Seq=2125043089 - 2125043211, Ack=1248728426, Win=64768 {TDS:676, TCP:675, IPv4:35}
    17278 4:23:16 PM 3/21/2012 1814.1305186 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Response, Version = 7.2 (0x72090002), SPID = 66, PacketID = 1, Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248728426 - 1248729886, Ack=2125043211, Win=62796 {TDS:676, TCP:675, IPv4:35}
    17279 4:23:16 PM 3/21/2012 1814.1306520 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17278]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248729886 - 1248731346, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17280 4:23:16 PM 3/21/2012 1814.1306585 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248731346, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17281 4:23:16 PM 3/21/2012 1814.1307636 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17278]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248731346 - 1248732806, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17282 4:23:16 PM 3/21/2012 1814.1308967 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17278]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248732806 - 1248734266, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17283 4:23:16 PM 3/21/2012 1814.1309015 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248734266, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17284 4:23:16 PM 3/21/2012 1814.1310178 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17278]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248734266 - 1248735726, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17285 4:23:16 PM 3/21/2012 1814.1310705 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17278]Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=700, Seq=1248735726 - 1248736426, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17286 4:23:16 PM 3/21/2012 1814.1310780 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248736426, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17287 4:23:16 PM 3/21/2012 1814.1317655 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Continuous Response, Version = 7.2 (0x72090002), SPID = 66, PacketID = 2, Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248736426 - 1248737886, Ack=2125043211, Win=62796 {TDS:676, TCP:675, IPv4:35}
    17288 4:23:16 PM 3/21/2012 1814.1318863 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17287]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248737886 - 1248739346, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17289 4:23:16 PM 3/21/2012 1814.1318907 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248739346, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17290 4:23:16 PM 3/21/2012 1814.1320033 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17287]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248739346 - 1248740806, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17291 4:23:16 PM 3/21/2012 1814.1321244 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17287]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248740806 - 1248742266, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17292 4:23:16 PM 3/21/2012 1814.1321289 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248742266, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17293 4:23:16 PM 3/21/2012 1814.1322552 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17287]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248742266 - 1248743726, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17294 4:23:16 PM 3/21/2012 1814.1323065 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17287]Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=700, Seq=1248743726 - 1248744426, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17295 4:23:16 PM 3/21/2012 1814.1323127 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248744426, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17296 4:23:16 PM 3/21/2012 1814.1332461 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248744426, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17297 4:23:16 PM 3/21/2012 1814.1707160 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TDS TDS:Continuous Response, Version = 7.2 (0x72090002), SPID = 66, PacketID = 3, Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248744426 - 1248745886, Ack=2125043211, Win=62796 {TDS:676, TCP:675, IPv4:35}
    17298 4:23:16 PM 3/21/2012 1814.1708378 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17297]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1460, Seq=1248745886 - 1248747346, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17299 4:23:16 PM 3/21/2012 1814.1708378 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Continuation to #17297]Flags=...AP..., SrcPort=1433, DstPort=56245, PayloadLen=46, Seq=1248747346 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17300 4:23:16 PM 3/21/2012 1814.1708467 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17430 4:23:46 PM 3/21/2012 1844.1763992 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17431 4:23:46 PM 3/21/2012 1844.1765826 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17432 4:23:46 PM 3/21/2012 1844.2093539 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17433 4:23:46 PM 3/21/2012 1844.2093652 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17563 4:24:16 PM 3/21/2012 1874.1752040 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17564 4:24:16 PM 3/21/2012 1874.1753935 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17565 4:24:16 PM 3/21/2012 1874.1848985 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17566 4:24:16 PM 3/21/2012 1874.1849091 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17695 4:24:46 PM 3/21/2012 1904.1603790 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17696 4:24:46 PM 3/21/2012 1904.1604009 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17697 4:24:46 PM 3/21/2012 1904.1739286 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17698 4:24:46 PM 3/21/2012 1904.1740750 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17849 4:25:16 PM 3/21/2012 1934.1359352 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17850 4:25:16 PM 3/21/2012 1934.1359527 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17851 4:25:16 PM 3/21/2012 1934.1727327 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17852 4:25:16 PM 3/21/2012 1934.1728795 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17958 4:25:46 PM 3/21/2012 1964.1715519 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    17959 4:25:46 PM 3/21/2012 1964.1717179 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17960 4:25:46 PM 3/21/2012 1964.2120881 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    17961 4:25:46 PM 3/21/2012 1964.2120981 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18047 4:26:16 PM 3/21/2012 1994.1859878 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18048 4:26:16 PM 3/21/2012 1994.1861384 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18049 4:26:16 PM 3/21/2012 1994.1876717 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18050 4:26:16 PM 3/21/2012 1994.1876796 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18172 4:26:46 PM 3/21/2012 2024.1632263 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18173 4:26:46 PM 3/21/2012 2024.1632489 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18174 4:26:46 PM 3/21/2012 2024.1847564 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18175 4:26:46 PM 3/21/2012 2024.1849025 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18271 4:27:16 PM 3/21/2012 2054.1463011 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18272 4:27:16 PM 3/21/2012 2054.1463202 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18273 4:27:16 PM 3/21/2012 2054.1835605 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18274 4:27:16 PM 3/21/2012 2054.1837101 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18393 4:27:46 PM 3/21/2012 2084.1823756 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18394 4:27:46 PM 3/21/2012 2084.1825361 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18395 4:27:46 PM 3/21/2012 2084.2148862 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18396 4:27:46 PM 3/21/2012 2084.2148961 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18496 4:28:16 PM 3/21/2012 2114.1904479 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18497 4:28:16 PM 3/21/2012 2114.1904718 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18498 4:28:16 PM 3/21/2012 2114.1967705 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18499 4:28:16 PM 3/21/2012 2114.1969163 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18601 4:28:46 PM 3/21/2012 2144.1660329 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18602 4:28:46 PM 3/21/2012 2144.1660500 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18603 4:28:46 PM 3/21/2012 2144.1955767 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18604 4:28:46 PM 3/21/2012 2144.1957368 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18724 4:29:16 PM 3/21/2012 2174.1415621 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18725 4:29:16 PM 3/21/2012 2174.1415816 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18726 4:29:16 PM 3/21/2012 2174.2099880 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18727 4:29:16 PM 3/21/2012 2174.2101584 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18814 4:29:46 PM 3/21/2012 2204.2177037 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=1, Seq=1248747391 - 1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18815 4:29:46 PM 3/21/2012 2204.2177270 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18816 4:29:46 PM 3/21/2012 2204.2243880 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive]Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=1, Seq=2125043210 - 2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18817 4:29:46 PM 3/21/2012 2204.2245338 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:[Keep alive ack]Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043211, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18862 4:29:56 PM 3/21/2012 2213.9746466 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:[Keep alive ack]Flags=...A...F, SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043211, Ack=1248747392, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}
    18863 4:29:56 PM 3/21/2012 2213.9749436 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...., SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043212, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18864 4:29:56 PM 3/21/2012 2213.9750610 BrunswickCounty.exe FULLSERVERNAME CLIENTPCNAME   TCP TCP:Flags=...A...F, SrcPort=1433, DstPort=56245, PayloadLen=0, Seq=1248747392, Ack=2125043212, Win=62796 (scale factor 0x0) = 62796 {TCP:675, IPv4:35}
    18865 4:29:56 PM 3/21/2012 2213.9750719 BrunswickCounty.exe CLIENTPCNAME   FULLSERVERNAME TCP TCP:Flags=...A...., SrcPort=56245, DstPort=1433, PayloadLen=0, Seq=2125043212, Ack=1248747393, Win=256 (scale factor 0x8) = 65536 {TCP:675, IPv4:35}

    Thanks,

    Mike

     
  • 29 martie 2012 02:08
    Moderator
     
     
    Sign in pentru a vota
    0

    Mike,

    You can find the vaule of 'Destination' column from the output of Network Monitor, please look into the SQL Server 2008 instance on this server. You can launch the Network monitor or SQL Server Profiler on the server side to caputre if there is any client trying to connect this instance.

    Stephanie Lv

    TechNet Community Support

     
  • 29 martie 2012 17:02
     
     
    Sign in pentru a vota
    0

    We have verified that the server and the client are talking and the packets are being transmitted back and forth.   Client is connecting to SQL prior to the failed call.   But is seems that as soon as the client sends the request use tds 7.3 is when it fails.   We see several 7.2 requests which are all successful then it send a 7.3 and it fails.   This is all within one conversation.

    I guess what i really need to know is how and why the client would decide to randomly select the tds 7.2 95% of the time but then start using the tds 7.3 within the same application and conversation.

    I may be able to isolate the problem if someone could explain how this works.  

    Thanks,

    Mike

     
  • 17 aprilie 2012 13:01
     
     
    Sign in pentru a vota
    0

    hi you can check out the below given link, it ma help you.

    http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

     
  • 17 aprilie 2012 13:45
     
     
    Sign in pentru a vota
    0

    Thanks,

    I have looked at that link in the past,  it didn't really help with my sitution.

    Mike

     
  • 5 octombrie 2012 14:34
     
      Are cod
    Sign in pentru a vota
    0

    Have you found a solution to this?  I am having this exact problem except the failed prelogin version is:

    Tds: Prelogin, Version = 7.300000(No version information available, using the default version), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56807, DstPort=1433, PayloadLen=47, Seq=707990433 - 707990480, Ack=2455406518, Win=65536

    and a successful prelogin:

    Tds: Prelogin, Version = 7.3 (0x730a0003), SPID = 0, PacketID = 1, Flags=...AP..., SrcPort=56771, DstPort=1433, PayloadLen=47, Seq=3572259441 - 3572259488, Ack=3804854218, Win=65536

    Another thing I just noticed is that the actual TDS section of the packet (not the tcp or ipv4 header stuff) of the two packets are identical when I look at them in hex.
     
© 2013 Microsoft. All rights reserved.