How to get the port number in SQL Server?
Note - The steps are shown through SQL Server 2012 environment. They are largely applicable to SQL Server 2014 too.
Step 1: Open the SQL Server Configuration Manager window through Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools
Step 2: Explore SQL Native Client 11.0 Configuration (32bit)
Step 3: Click on Client Protocols option within it –
Step 4: Double click on TCP/IP from the right hand side pane
We will get to know the Default Port as shown here
The default port > 1433 port is the official Internet Assigned Number Authority (IANA) socket number for SQL Server. Client systems use TCP 1433 to connect to the database engine; SQL Server Management Studio (SSMS) uses the port to manage SQL Server instances across the network. You can reconfigure SQL Server to listen on a different port, but 1433 is by far the most common implementation.
Some other default SQL Server ports:
TCP 1434 – For Dedicated Admin Connection
UDP 1434 – For SQL Server Named Instance
TCP 2383 – For Default port of SSAS
TCP 2382 – For Named instances of SSAS
TCP 135 – For SSIS & T-SQL Debugger
TCP 80 and 443 – For SSRS
TCP 4022 – For Service Broker