Tools and methods that help you troubleshoot connectivity issues Configure firewalls to work with SQL Server. ... Test connections to SQL Server by using Universal Data Link (UDL) files. ... Use PortQryUI tool with SQL Server. ... Check whether SQL Server is listening on dynamic or static ports. More items... Dec 29, 2022