How can I use SQL Server Configuration Manager to diagnose TCP/IP issues?

Question

Grade: Education Subject: Support
How can I use SQL Server Configuration Manager to diagnose TCP/IP issues?
Asked by:
73 Viewed 73 Answers

Answer (73)

Best Answer
(324)
In SQL Server Configuration Manager, navigate to SQL Server Network Configuration -> Protocols for . Select TCP/IP and click Properties. Review the IP Addresses tab to ensure the correct IP addresses are enabled and listening on the expected ports. Also, check the 'Flags' section for any unusual settings.