LISTENER_IP = ALL | (4-part-ip ) | ( "ip_address_v6" )
Specifies the IP address that the endpoint will listen on. The default is ALL. This means that the listener will accept a connection on any valid IP address.
If you configure database mirroring with an IP address instead of a fully-qualified domain name (ALTER DATABASE SET PARTNER = partner_IP_address or ALTER DATABASE SET WITNESS = witness_IP_address), you have to specify LISTENER_IP =IP_address instead of LISTENER_IP=ALL when you create mirroring endpoints.

sej2008 (3/4/2013)

---

when I create mirror endpoint I define the port number in it now if only one
endpoint allowed per instance then how can i use different port number for two mirroring session on an instance still confused.....????

Lynn Pettis (3/3/2013)

---

First answer, yes. You can only have one mirroring endpoint per instance.

Regarding the second question, from MSDN:

sej2008 (3/5/2013)

---

let me make it clear what I want is u have
Server1 and two seperate instances
wherein db1 is mirroring with db2 ( endpoint MIrroring1)

now you have db3.....db4 mirroring session on same server(machine)endpoint(Mirroring1)
port number is 5022 for db1 ,portnumber for db2=5023
then what port number should be there for db3 and db4 that uses same endpoint (Mirroring1)for their mirroring session
Pls explain....