how to find port no in sql server 2005?

hi all

i am wirking on sql server 2005.

is there ab=ny way by which we can come to know , on which port the sql server database engine service is running?

eventhough i know that it runs on port no 1434 , but still i want to know the way by which we can finf out this.

plz help me.

Easiest way would be tun run netstat and see which port is listened to or run the configuration utilities.

HTH, Jens Suessmeyer.

http://www.sqslerver2005.de|||

From within SQL Server 2005 you can run the following and check local_tcp_port column:

select * from sys.dm_exec_connections

This DMV is described in Books Online: http://msdn2.microsoft.com/en-us/library/ms181509.aspx

HTH,

Boris.