SQL Server

SQL Server Default Port

AWS-in 2016. 9. 1. 13:24

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

   

[출처]

http://www.sqlservercurry.com/2016/08/sql-server-default-port_30.html?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+sqlservercurry%2Fblog+%28Sql+Server+2005%2F2008+Blog+With+Tips+Tricks+and+Articles%29