GET SQL Server Port

 How to Get SQL Server Port

select distinct local_net_address, local_tcp_port 

from sys.dm_exec_connections where local_net_address is not null

CONFIGURE statement to Set Query TimeOut 600 to 0

 Configuration option 'remote query timeout (s)' changed from 600 to 0. 

 

GO  

EXEC sp_configure 'remote query timeout', 0 ;  

GO  

RECONFIGURE ;  

GO