Hi,

I'm running a syncornized mirroring setup using a witness on our LAN.

Since we don't use a domain controller, we use certificates for outbound and
inbound mirroring connections.

We're using sql server 2005 SP1 standard edititon on all machines.

The principal and mirror have only the partner role

The witness has only the witness role

After exeucting 'alter database set witness' on server1, the mirror monitor
shows that server1, the pricnipal, is connected to the witness, but server2,
the mirror, is disconnected from the witness.

When performing a manual failover (alter databsase set partner failover),
server2, now the principal, is still disconnected from the witness.

I've eliminated the possibility that server2 and the witness have a
connection problem, by dropping the witness from server1 when server1 was the
principal, and adding it to server2, when server2 was the principal. Then,
server1 is the one with the disconnected problem.

When executing the set witness command on a mirror, I get an error that it
can only be done on the principal machine.

Any ideas?

Thanks,
Ronen