Finding the Port of MS SQL Named Instance

When running a named instance of MS SQL the instance will run on a port other than the usual port 1433. To determine the port you can use the following query:

DECLARE @tcp_port nvarchar(5)

EXEC xp_regread
@rootkey    =    'HKEY_LOCAL_MACHINE',
@key        =    'SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL\MSSQLSERVER\SUPERSOCKETNETLIB\TCP',
@value_name    =    'TcpPort',
@value        =    @tcp_port OUTPUT

select @tcp_port

In my case the instance was named "MSSQL".