Microsoft SQL Server Port Number : 1433

The default Microsoft SQL Server Port Number is 1433 – Client ports are assigned a random value between 1024 and 5000. Full port listings can be seen here

Default MySQL Server Port = 3306

As a network admin this is important stuff – you’ll need to allow these ports on the firewall…

Comprehensive SQL Server port information is listed here for you refer to, and we tell you how to find the port numbers used by the clients connected to the SQL server.

We’ll also cover SQL Server instances (named instances get a random SQL port number) as well and explain what they are, and how they work ‘in the cloud’ on VMs.

This is a knowledgebase of Microsoft SQL Server Port configuration details to help get your SQL server up and running.

We’ve also got some screenshots and tutorials, and information on MySQL Server port numbers and other SQL Databases.

SQL Server Port Numbers – How to Change them

This is the site to learn how to find and change SQL Server Port Numbers!

A useful list of default port numbers for other applications including Microsoft SQL Server ports, and MySQL ports can be found at

http://www.iss.net/security_center/advice/Exploits/Ports/default.htm

Connect to SQL Server through a Firewall

We also cover how to allow a connection to an SQL server through a firewall, and port forwarding.

Open the firewall port for SQL Server on Windows Server 2008

Save this as openport.bat and run on the computer that has the blocking firewall

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"
@echo Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"
@echo Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL"
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser"
@echo Allowing multicast broadcast response on UDP
(Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

Note :  SQL Server port : 1434 gets opened as well

SQL Server Port Number Summary : 

1. The Default Microsoft SQL Server port is 1433 but only if it’s a default install. Named instances get a random port number.
2. The browser service runs on port UDP 1434.
3. Reporting services is a web service – i.e  port 80, or 443 if it’s SSL enabled.
4. Analysis services runs on 2382 for default install. Named instances get a random port number

This site is dedicated to information about SQL Server Port Numbers

If you have any comments or queries contact me on twitter - http://twitter.com/#!/SQL_ServerPort