How to check the sqlserver database port number

SQL Server database port number can be viewed through SQL Server Configuration Manager: Open SQL Server Configuration Manager. Expand SQL Server Network Configuration. Select protocol (TCP or UDP). View the port number in the TCP Port field. Common port numbers: TCP 1433 (default), UDP 1434 (default), TCP 11433 (dynamic). If you experience connection problems, check your firewall settings or contact your database administrator.

How to check the SQL Server database port number

Open SQL Server Configuration Manager

1. Press Windows key R to open the run window.
2. Enter sqlserver_config and press Enter.

Find the port number

1. In the left panel, expand SQL Server Network Configuration.
2. Select Protocol.
3. In the right panel, select the protocol for which you want to view the port number.
4. View the port number in the TCP Port field.

Common port numbers:

• TCP port 1433: Default port
• UDP Port 1434: Default port
• TCP Port 11433: Dynamic port

Note:

• The port number can be changed by modifying it in SQL Server Configuration Manager.
• Make sure the firewall allows connections through these ports.
• If you are unable to connect to the SQL Server database through these ports, check your firewall settings or contact your database administrator.

The above is the detailed content of How to check the sqlserver database port number. For more information, please follow other related articles on the PHP Chinese website!