To view the port number of the SQL Server database

Recently, using SQL Server as a Java database for development, when writing the connection string, think of a problem, how to find the port number of SQL Server? There are two ways

1, using Stored procedures

--Query port number
EXEC Sys.sp_readerrorlog 0, 1, ' Listening '

The results are as shown

Which one do you choose? 127.0.0.1:1433 is used here.

2, using SSCM for Management (SQL Server Configuration Manager)

Then right-click TCP/IP and select Properties

After you modify, save and then restart the SQL Server servers to

To view the port number of the SQL Server database