How To Find SQL Server TCP IP Port Number Using SQL Query

Hi Friends,

In this video tutorial ,I am going to explain How To Find SQL Server TCP IP Port Number Using SQL Query

USE MASTER
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO

#SQL TCP IP PORT NUMBER #T-SQL #How To Find SQL Server Listening TCP IP Port Number #1433 #Default TCP Port Number

Thnaks

[cmnorton]

Your video just saved my postponing an install for our Inspections Department. The default SQL instance is 1433 of course, but the named instance is something else. Phew! and Thanks.