This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 9%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
How to find out what Microsoft SQL Server 2022 port you are using with an instance ?
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @sd xzzx
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya
Hi @sd xzzx
Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Best regards,
Aniya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
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';
Hi @sd xzzx
Yes, as Erland said, you can use SQL Server Configuration to view port numbers.
Best regards, Aniya
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.