Which port does SQL Server clients (Enterprise Manager, Query Analyzer, etc) use?

NOTE: We strongly recommend migrating from SQL 2000 to SQL 2005 or 2008. As Microsoft continues to move forward with SQL server technology, SQL 2000 will fall further behind the standard. It is no longer actively developed or updated, as it has been superseded by SQL 2005 and 2008. While we will continue to maintain our existing SQL 2000 servers, our recommendation is to upgrade your SQL service to a more recent version at your earliest possible convenience.

If you decide to migrate your SQL database we have a forum post on the steps needed to complete this process.

SQL Clients (Enterprise Manager, Query Analyzer, etc) use TCP port 1433. If you cannot connect to our SQL Server, make sure port 1433 is not blocked by your firewall.

Note: Some ISPs do not allow port 1433 connections to go through their network. If you find that to be that case, you can configure your SQL client to connect via the alternative port, 14330.

Article ID: 211, Created On: 11/14/2008, Modified: 4/7/2011