Every one knows that by default any version of SQL Server Uses 1433. how to check the port used by SQL Server.

1:

execute

use master
go
xp_readerrorlog 0,1,N’Server is listening on’,’any’,NULL,NULL,N’asc’

in the management studio

Option 2

OPtion 3

run this query in the SQL  Server Management Studio

select distinct local_net_address, local_tcp_port
from sys.dm_exec_connections
where net_transport = ‘tcp’

Leave a Reply

Your email address will not be published. Required fields are marked *