Cookbook Scripts - microsoft/CSS_SQL_Networking_Tools GitHub Wiki

Cookbook Scripts

This section contains various SQL, PowerShell, VBScript, and CMD scripts to perform various tasks.

Collect the Connectivity Ring Buffer

Determine If I Am Connected to SQL Server using Kerberos Authentication

Determine I have Delegatable Credentials in my ASPX Web Site

Enumerate SQL Server Instances and TCP Settings

One-Line PowerShell Scripts

Description Command
Can the server be reached Test-NetConnection sqlprod01.contoso.com -port 1433
List Jumbo Frames Settings Get-NetAdapterAdvancedProperty
You can also see this in the SQLCheck output

Chained NETSH Scripts

Collecting NETSH and LOGMAN with Additional Providers

StartChainedCap.cmd

netsh trace start capture=yes maxsize=1 TRACEFILE=.\deleteme.etl REPORT=disabled
logman start trace ndiscap -p Microsoft-Windows-NDIS-PacketCapture -mode newfile -max 200 -o .\%computername%%%d.etl -ets
logman update trace ndiscap -p Microsoft-Windows-Winsock-AFD -ets
logman update trace ndiscap -p Microsoft-Windows-TCPIP -ets

StopChainedCap.cmd

logman stop ndiscap -ets
netsh trace stop
del .\deleteme.etl
⚠️ **GitHub.com Fallback** ⚠️