Troubleshooting SQL Server listener connectivity

Verifying and troubleshooting SQL Server listener connectivity is a key component in a DBAs armoury but often overlooked until now this post shows how to confirm connectivity to SQL Server using any of its connectivity options such as TCP/IP, Named Pipes or Shared Memory.

SQL Server listeners Verifying and troubleshooting SQL Server listener connectivity is a key component in a DBAs armoury but often overlooked until now (hopefully!). SQL Server can listen for connection requests via multiple listeners, such as TCP/IP, shared memory or named pipes. Sometimes it’s necessary to check connectivity by a specific listener. The first place […]