How to check the port number of sqlserver2014

Port number query of SQL Server 2014

The default port number of SQL Server 2014 is 1433. You can quickly find the port number of your instance using the following steps:

Step 1: Open SQL Server Configuration Manager

• In the Windows Start menu, search for and open "SQL Server Configuration Manager".

Step 2: Navigate to SQL Server Network Configuration

• In the left pane, expand the SQL Server Network Configuration node.

Step 3: Select the corresponding SQL Server instance

• In the right pane, select the SQL Server instance for which you want to query the port number .

Step 4: View the TCP/IP port number

• Under the TCP/IP tab, find the IP Address section.
• In the TCP Port field, you will see the port number configured for the instance.

Other available port numbers

Although 1433 is the default port number, you can specify a different port number during or after installation. If a different port number is specified, you need to use the specified port number to connect to the instance.

You can view the port numbers of all SQL Server instances in the command prompt using the following command:

netstat -aon | find "LISTENING" | find "sqlserver"

This will display all SQL Server instances that are listening for connections, and the ports they use Number.

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