What ports does SQL Server need?

After SQL Server is installed on the Server, all unused ports need to be blocked and only necessary ports must be opened for the sake of Server security. The following describes the ports used in SQL Server 2008:

First, port 1433 is the most common. This is the port of the database engine. If we want to remotely connect to the database engine, we need to open this port. This port can be modified. In "SQL Server Configuration Manager", switch to "XXX protocol" and select "TCP port. :

SSIS needs to call the DCOM protocol, so port 135 must be enabled when using SSIS, and this port cannot be changed. Service Control Manager (SCM) can be accessed only when TCP port 135 is enabled ). SCM executes the following tasks: start and stop the Integration Services service, and transmit control requests to the running service.

Next, let's talk about SSAS. The default SSAS instance uses port 2383. If the instance is named, each instance will have a port specified by the Administrator, which can also be dynamically allocated, we strongly recommend that you do not use the dynamic port allocation scheme because of the need for network security.If the port is dynamically allocated, the client will connect to port 2382 of the Server when connecting to the Server. This port is the port used by SQL Server Browser. The SQL Server Browser then uses port 2382 to tell the client the actual port number of the instance to be connected. (This is an official statement, but I'm not sure port 2382 is required here, but the UDP1434 port mentioned next is certainly useful .)In addition, the SQL Server Browser needs to use UDP port 1434, so if you need to use this service, you must open UDP1434. To modify the SSAS port, open the SSAS service, connect to SSAS using SSMS, right-click the instance in the object resource manager, and select properties. The Analysis Service Properties window is displayed, set the Port attribute to the required Port. The default value is 0, which means that the Port is not set. Then restart the SSAS service.

After the restart, if SSMS obtains other clients to connect to SSAS, it needs to use the "host name: Port" method to connect to the host. If it is a database engine, it uses the "host name, port format.

The report service provides services through the Web. Therefore, by default, the report service uses port 80. Of course, you can modify the port of the report service, modify the Web service and report manager ports in the report service Configuration Manager ,:

SSB port configuration. If SSB involves communications between computers over the network, you need to set an EndPoint. When setting an SSB EndPoint, you need to set a listening port, for example, we create an endpoint:

USE master;GOCREATE ENDPOINT BrokerEndpoint    STATE = STARTED    AS TCP ( LISTENER_PORT = 4037 )    FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;GO

Then we need to develop port 4037.

Similarly, if we want to configure database images and SOAP access, we also need to create an endpoint and activate the port in the endpoint.

In addition to the ports described above, if you want to copy a database, you need to set a shared folder on the database server to facilitate data transmission between multiple servers, you also need to activate Windows Shared ports, such as 137, 138, 139, and 445.

The above describes so many services and ports, which need to be set according to actual needs. For security reasons, you can set the default port as your own port, and do not open the SQL Server Browser Service.