Let's say I have 4 SQLServer 2012 R2 divided into two mirrors:
- SQL1-1 with its mirror SQL1-2. The Witness is SQL2-2.
- SQL2-1 with its mirror SQL2-2. The Witness is SQL1-2.
The mirorring has been created with GUI, so I have only one endpoint for mirorring on each server :
TCP://SQLx-x.fqdn.lan:5022 (except built-in endpoints like NamedPipes, etc).
So, for servers SQL1-2 and SQL2-2, this endpoint is used for mirorring AND witnessing of the other mirror. Can this be a problem?
This question came because of an unexpected failover last night and this message in event logs :
An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Target, far endpoint address: '')
Here is a solution (restarting endpoints) which didn't worked for me.
Additional informations :
- I can
telnet TCP://SQLx-x.fqdn.lan 5022from every servers
- Endpoints permissions seems to be fine
Thanks, and sorry for my poor english.