首页 > 数据库 >sql server pre-login troubleshooting

sql server pre-login troubleshooting

时间：2023-12-21 15:02:13浏览次数：313  
标签：pre x.1 1433 ACK TCP server Len login x.100

wireshark抓包之后，首先过滤数据库服务器的IP

ip.src==172.22.58.4 or ip.dst==172.22.58.4

找到第一条TCP握手记录之后，右键选中，Follow TCP stream

然后会自动标记筛选出，从握手到断开的所有packet数据包

tcp.stream eq 56

 

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

Login Annotated

The following table contains a high-level annotation of the SQL login and a select @@VERSION from sqlcmd.

 

 

No.

Source

Destination

Protocol

Length

Info

Client sends TCP open request to SQL Server (SYN) computer

9489

x.x.x.1

x.x.x.100

TCP

66

56369  >  1433 [SYN] Seq=0 Win=65280 Len=0 MSS=1360 WS=256 SACK_PERM=1

TCP acknowledges request (If port was incorrect this is where server sends RST 10054)

9490

x.x.x.100

x.x.x.1

TCP

66

1433  >  56369 [SYN, ACK] Seq=0 Ack=1 Win=8192 Len=0 MSS=1396 WS=256 SACK_PERM=1

 

9491

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=1 Ack=1 Win=262400 Len=0

SQL Client sends TDS pre-login

9492

x.x.x.1

x.x.x.100

TDS

142

TDS7 pre-login message

SQL Server responds to pre-login request

9493

x.x.x.100

x.x.x.1

TDS

102

Response

 

9494

x.x.x.1

x.x.x.100

TDS

250

TDS7 pre-login message

 

9495

x.x.x.100

x.x.x.1

TCP

1414

1433  >  56369 [ACK] Seq=49 Ack=285 Win=262144 Len=1360 [TCP segment of a reassembled PDU]

 

9496

x.x.x.100

x.x.x.1

TCP

1414

1433  >  56369 [ACK] Seq=1409 Ack=285 Win=262144 Len=1360 [TCP segment of a reassembled PDU]

 

9497

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=285 Ack=2769 Win=262400 Len=0

 

9498

x.x.x.100

x.x.x.1

TCP

1414

1433  >  56369 [ACK] Seq=2769 Ack=285 Win=262144 Len=1360 [TCP segment of a reassembled PDU]

Ssl/Tls negotiation packet exchange (SQL Client InitializeSecurityContext -> SQL Server AcceptSecurityContext)

9499

x.x.x.100

x.x.x.1

TDS

70

TDS7 pre-login message (Not last buffer)

 

9500

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=285 Ack=4145 Win=262400 Len=0

Note: The SQL Server can send a RST for 5 second timeouts in this exchange window.

9501

x.x.x.100

x.x.x.1

TDS

428

TDS7 pre-login message

 

9502

x.x.x.1

x.x.x.100

TDS

188

TDS7 pre-login message

 

9503

x.x.x.100

x.x.x.1

TDS

113

TDS7 pre-login message

End of Ssl/Tls negotiation process

9504

x.x.x.1

x.x.x.100

TDS

349

TLS exchange

 

9505

x.x.x.100

x.x.x.1

TCP

54

1433  >  56369 [ACK] Seq=4578 Ack=714 Win=261632 Len=0

SQL Client sends Login information (SendLogin)

9506

x.x.x.100

x.x.x.1

TDS

800

TLS exchange

 

9507

x.x.x.1

x.x.x.100

TDS

163

TLS exchange

Note: The client can send a RST to honor the login timeout during this window

9509

x.x.x.100

x.x.x.1

TDS

125

TLS exchange

 

9510

x.x.x.1

x.x.x.100

TDS

147

TLS exchange

 

9511

x.x.x.100

x.x.x.1

TDS

120

TLS exchange

SQL Server finishes acknowledgement of successful login after sending back config info (language, …)

9512

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=916 Ack=5461 Win=261120 Len=0

Idle keep alive, client not doing anything (sqlcmd at prompt)

9627

x.x.x.1

x.x.x.100

TCP

55

[TCP Keep-Alive] 56369  >  1433 [ACK] Seq=915 Ack=5461 Win=261120 Len=1

 

9628

x.x.x.100

x.x.x.1

TCP

66

[TCP Keep-Alive ACK] 1433  >  56369 [ACK] Seq=5461 Ack=916 Win=261632 Len=0 SLE=915 SRE=916

 

9629

x.x.x.100

x.x.x.1

TCP

55

[TCP Keep-Alive] 1433  >  56369 [ACK] Seq=5460 Ack=916 Win=261632 Len=1

 

9630

x.x.x.1

x.x.x.100

TCP

66

[TCP Keep-Alive ACK] 56369  >  1433 [ACK] Seq=916 Ack=5461 Win=261120 Len=0 SLE=5460 SRE=5461

SQL Client sends query (select @@VERSION)

9741

x.x.x.1

x.x.x.100

TDS

149

TLS exchange

SQL Server responds with version information

9743

x.x.x.100

x.x.x.1

TDS

337

TLS exchange

 

9744

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=1011 Ack=5744 Win=262400 Len=0

SQL Client sends disconnect request and closes TCP connection

9772

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [FIN, ACK] Seq=1011 Ack=5744 Win=262400 Len=0

 

9773

x.x.x.100

x.x.x.1

TCP

54

1433  >  56369 [ACK] Seq=5744 Ack=1012 Win=261376 Len=0

 

9774

x.x.x.100

x.x.x.1

TCP

54

1433  >  56369 [FIN, ACK] Seq=5744 Ack=1012 Win=261376 Len=0

Server acknowledges TCP closure

9775

x.x.x.1

x.x.x.100

TCP

54

56369  >  1433 [ACK] Seq=1012 Ack=5745 Win=262400 Len=0

 

SNI Tracing

Understating where the TCP Close (RST) originates provides you with diagnostic guidance.   A general rule for login is if the SQL Server sends the RST it is probably a client issue and if the SQL client provider sends the RST is it probably a SQL Server issue. 

 

标签：pre,x.1,1433,ACK,TCP,server,Len,login,x.100
From： https://www.cnblogs.com/chucklu/p/17919052.html

相关文章

  • SQL SERVER上课笔记
    SQL数据库笔记##############目录 SQL数据库笔记############## 一、初次使用数据库 .二、用SSMS工具工具采用图形化的方法创建数据库（第二种方法通过T-SQL语句创建数据库） 三、利用T-sql创建数据库 四、删除数据库 五、数据库的相关操作分离，附加，改变数据库......
  • helm upgrade rancher server from v2.7.5 to v2.7.8 in kubernetes【helm 升级 ranch
    文章目录1.预备条件2.目标3.下载介质4.镜像入库5.升级rancher6.检查测试1.预备条件KubernetesClusterHelm&KubernetesOfflineDeployRancherv2.7.5Demo注意：如果你是在vcenter的虚拟机测试该应用，记得给当前版本做好快照，便于反复练习。2.目标rancherv2.7.5升级......
  • ubuntu 18.04.6 编译Preloader提示 没有规则可制作目标 /host_tools/altera/preloader
     生成spl_bsp后，在spl_bsp路径下输入make 提示：没有规则可制作目标/host_tools/altera/preloader/uboot-socfpga.tar.gz 原来要先运行 ./embeddedcommandshell.sh，并在该终端窗口下输入make   ......
  • libevent http-server示例
    wgethttps://github.com/libevent/libevent/releases/download/release-2.1.12-stable/libevent-2.1.12-stable.tar.gztarxvzflibevent-2.1.12-stable.tar.gz-C.cdlibevent-2.1.12-stablemkdircmake-build-debugcdcmake-build-debugcmake../-DCMAKE_BUILD_TYPE......
  • 报错: Failed to execute ‘append‘ on ‘FormData‘: 2 arguments required, but on
    未能对“FormData”执行“append”：需要2个参数，但仅存在1个参数。  letformData=newFormData()本来formData.append(‘list’，JSON.stringify(arr))  改成下边这样了，就报错了formData.append(JSON.stringify(arr))正确的写法应该是： fd.append("参数名",值") ；我们......
  • SQLSERVER导入EXCEL数据
    1、整理好对应的EXCEL表格数据，要有标题行。否则无法映射。 2、登录进入SQLSERVER数据库管理软件，选中要导入的数据库，右键-->点击任务-->选择导入数据  3、点击下一步，直到这个页面，数据源下拉选择EXCEL，选择文件路径，勾选首行包含列名称3、（1）如果点击下一步报错The'Microsof......
  • 界面控件DevExpress WinForms PDF Viewer，让应用轻松显示PDF文档（一）
    DevExpressWinForms的PDFViewer（查看器）控件使用户可以轻松地在Windows应用程序中直接显示PDF文档，而无需在最终用户的机器上安装外部PDF阅读器。DevExpressWinForms有180+组件和UI库，能为WindowsForms平台创建具有影响力的业务解决方案。同时能完美构建流畅、美观且易于使用的应......
  • Github Actions - Error: The connection to the server localhost:8080 was refused
     Runkubectlapply-feks/aws-auth.yamlkubectlapply-feks/aws-auth.yamlkubectlapply-feks/deployment.yamlkubectlapply-feks/service.yamlshell:/usr/bin/bash-e{0}env:AWS_DEFAULT_REGION:ap-southeast-1AWS_REGION:ap-southe......
  • 论文阅读-Self-supervised and Interpretable Data Cleaning with Sequence Generativ
    1.GARF简介代码地址：https://github.com/PJinfeng/Garf-master基于SeqGAN提出了一种自监督、数据驱动的数据清洗框架——GARF。GARF的数据清洗分为两个步骤：规则生成(RulegenerationwithSeqGAN)：利用SeqGAN学习数据中的关系(datarelationship)。然后利用SeqGAN中......
  • An Introduction to Bioinformatics Algorithms, Neil C. Jones and Pavel Pevzner, t
    AnIntroductiontoBioinformaticsAlgorithms,NeilC.JonesandPavelPevzner,theMITPress,2004. Thisintroductorytextoffersaclearexpositionofthealgorithmicprinciplesdrivingadvancesinbioinformatics.Accessibletostudentsinbothbiology......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99