What ports do SQL Server 2008 really need to use? _mssql

Here's a description of what ports are used in SQL Server 2008:

First, the most commonly used is the 1433 port. This is the port of the database engine, and if we want to connect to the database engine remotely, then we need to open the port. This port can be modified by switching to the "Protocol for XXX" option in SQL Server Configuration Manager, and TCP ports can be set in the TCP/IP protocol properties. As shown in the figure:

SSIS will invoke the DCOM protocol, so you need to open port 135 when you use SSIS, and this port cannot be changed. The Service Control Manager (SCM) can be accessed only by opening TCP port 135. SCM performs the following tasks: Starting and stopping the Integration Services service, and transferring control requests to the running service.

Let's talk about it. Ssas,ssas the default instance uses port 2383, and if it is a named instance, then each instance has an administrator-specified port, which can also be dynamically allocated, and it is strongly recommended that you do not use dynamic allocation of ports due to network security. If the port is dynamically allocated, the client will connect to the server's 2382 port when it connects to the server, which is the port used by SQL Server Browser. SQL Server Browser again tells the client via port 2382 that the actual port number of the named instance to which you want to connect is required. (This is official, but I'm not sure this is a 2382 port, but the UDP1434 port that follows is definitely useful.) Additionally, SQL Server browser needs to use port 1434 for UDP, so if you need to use the service, you must open the UDP1434.

To modify the ports for SSAS, you need to open the SSAS service first, then use SSMS to connect to SSAS, right-click the instance in Object Explorer, select Properties, pop up the Analysis Service Properties window, set the port property to the ports you want, and the default value is 0, which means no setting. Then restart the SSAS service.

After restarting, SSMS obtains other client connection SSAS, then need to use "host Name: Port" As the connection host, and if the database engine, then use "host name, port" format, these two are different.

Wordend Related reading: In-depth understanding of SQL Server 2008 high Availability performance damage SQL Server 2008 Full-Text Search video: SQL Server 2008 Overview

Reporting Services are serviced through the Web, so the report service uses port 80 by default, and of course users can modify the port of the report service and modify the Web service and Report Manager ports in Report service Configuration Manager, as shown in the figure:

SSB port configuration, SSB if it involves the communication between computers over the network, you need to set the endpoint (EndPoint), and when you set the endpoint of SSB, you need to develop a listening port, such as we create an endpoint:

Copy Code code as follows:

Use master;
Go
CREATE ENDPOINT Brokerendpoint
State = Started
As TCP (Listener_port = 4037)
For Service_broker (authentication = WINDOWS);

Go then we need to develop 4037 ports.

Similarly, if we want to configure database mirroring, SOAP access, and so on, we also need to create endpoints and open ports in the endpoints.

In addition to the above mentioned port, if you want to do database replication and so on, you need to set up a shared folder on the database server to facilitate the transmission of multiple servers, then also need to open windows sharing ports, such as 137, 138, 139, 445 and so on.

These services and ports are described above, which need to be set according to actual needs, for security reasons you can use the default port as your own port, and the SQL Server Browser service does not open.

--> -->