- Download and extract the PortQuery UI tool from PortQuery.
- Run PortQueryUI.exe
- Enter the server name in the Enter Destination IP or FQDN to query field
- Mark the Query predefined service option and select SQL Service in the Service to query field
- Click the Query button. PortQuery checks UDP 1434 and returns data from SQL Server (or SQL Browser in SQL 2005). This will show each of the instances running on the server and their ports. If the service returns FILTERED, the port is firewalled.
- If necessary, manually set the specific port of the instance the workstation is attempting to connect to and re-query. To determine the port that is being used by SQL Server, refer to How to find the port being used by SQL Server (BB134012).
For more information about PortQuery, refer to Microsoft Knowledgebase solution 832919.
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.