Database Mirroring : How to find the TCP port being used for mirroring?

Hi,

I am interested in finding the TCP port which has been setup on a principal/witness/mirror server.

I have queried thesys.database_mirroring_endpointsandsys.endpoints systemviews but nowhere does it specify the TCP port.

I think the only way to find out is to go to one of the mirrored databases and to right click properties-->Mirroring. I think this is ugly way to find out the TCP port, so if anyones found a better way to find this do tell....
Cheers,
Priyanga

[707 byte] By [Priyanga] at [2008-2-7]

«« Calling Member Functions of unmanaged Class in a DLL
»» WM_SIZE message problem

# 1

select * from sys.tcp_endpoints

may be what you're looking for...

-Keith.

Slamhart at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Database Engine...

# 2

Thanks Keith.

Priyanga at 2007-9-9 >

SQL Server

SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Database Mirroring : How to find the TCP port being used for mirroring?...'

Database Mirroring : How to find the TCP port being used for mirroring?

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified