I have the Principal server and mirrored server placed on one VLAN and the witness server on another vlan. The port assigend to all these servers is 5022.
The problem we are facing is that the witness server though successfully being configured for database mirroring is not doing the automatic failover.
In the view Mirroring Monitor, the status under witnesss server shows disconnected for Mirrored server and is blank for Principal Server.
The project is in production so require urgent help!!