Windows Remote Desktop: 3389
(1) sqlserver service uses two ports: TCP-1433, UDP-1434. 1433 is used to provide external services for sqlserver, and 1434 is used to return the TCP/IP Port used by sqlserver to the requester.
You can use the Enterprise Manager of SQL Server to change the default TCP port of SQL Server. The method is as follows:
A. Open Enterprise Manager, select "Microsoft SQL servers-SQL Server group" in the left-side toolbar, and open "SQL instance" (the name of the SQL Server server to be modified in the actual environment) in the Properties dialog box, click "network configuration (n)" at the bottom of the "General" tab to open the "SQL SERVER network tools" dialog box.
B. There are TCP/IP protocols in the "enabled protocols" list. Enter the port number to be modified in the default port options in the properties. Another option is to hide the server. If this option is selected, the client cannot view this server by enumerating the server, which protects the server and does not affect the connection.
(2) SQLAgent service uses TCP-1625, TCP-1640 port to provide services.
(3) The SQL query analyzer accesses port 1601 through port 1433 and connects to sqlserver.