본 게시물은 개인적인 의견으로 작성되었으니 절대적인 정보가 아닐 수 있습니다. 참고만 하시고 궁금한 사항이 있으시면 연락주세요.

티스토리 뷰

SQL Server - CATEGORY

SQL Server Default Port

시퀄人 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

   

댓글
댓글쓰기 폼
1 ··· 48 49 50 51 52 53 54 55 56 ··· 328