Skip to main content

How to identify SQL port has been used


select max(local_tcp_port) from sys.dm_exec_connections where net_transport ='TCP'


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




Comments