Query to find the SQL server instance port number

— Check the port number from error log
EXEC xp_ReadErrorLog 0, 1, N’Server is listening on’, N’any’, NULL, NULL, ‘DESC’
GO
— Check the port number using DMV , dont run this script from rigistered servers session
SELECT local_tcp_port
FROM sys.dm_exec_connections
WHERE session_id = @@SPID
GO