Find out this post message asked info ?

Question

How to find out what Microsoft SQL Server 2022 port you are using with an instance ?

Answer 1

You can use SQL Server Configuration Manager. Go to the node SQL Server Network Configuration. Find the server, select TCP/IP, right-click, select Properties and go to the IP Addresses and scroll to the bottom, and it will be one of TCP Dynamic Ports or TCP port.

You can also see it in the SQL Server errorlog. Around line 50 when SQL Server starts up, you will find a line like:

Server is listening on [ 'any' <ipv6> 42564] accept sockets 1.

Answer 2

Hi @sd xzzx Yes, as Erland said, you can use SQL Server Configuration to view port numbers.

Best regards, Aniya

Answer 3

Hi @sd xzzx,

You need to be on the server to use SQL Server Configuration Manager. Probably, it is easiest to do via T-SQL. Please try the following in SSMS.

USE master;
GO
EXEC xp_readerrorlog 0, 1, N'Server is listening on', N'any', NULL, NULL, N'asc';