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
The error message is exactly correct. You run an alter database set partner
on both the principal and the mirror. You only run the alter database set
witness on the principal. That command option is never run against the
mirror. It looks like you have either a certificate issue or you have a
connectivity problem. If the principal and mirror are server1 and server2,
what is the name of the witness?
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com
"Ronen" <Ronen@.discussions.microsoft.com> wrote in message
news:C3C6E7E5-AA18-4A24-BC34-3C378D05A41D@.microsoft.com...
> 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
>
sql
Wednesday, March 28, 2012
Persistent mirroring witness disconnected probem on mirror
Labels:
certificates,
controller,
database,
disconnected,
domain,
lan,
microsoft,
mirror,
mirroring,
mysql,
oracle,
persistent,
probem,
running,
server,
setup,
sql,
syncornized,
witness
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment