Friday, 16 October 2015

Using Query to find the Port No on which SQL Server is Running

Using xp_readerrorlog

Execute following stored procedure on the instance where you want to find out port on which SQL Server is running.
USE MASTER
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO

The above query will return results something very similar to the following:
xpport SQL SERVER Find Port SQL Server is Listening Port SQL Server is Running

No comments:

Post a Comment