Connection handshake failed - easiest possible configuration
Hi there!
Often discussed, but not really solved in my opinion - the connection between the partners and the witness causes problems.
My case: Three Servers in the same domain, three endpoints on 5022 with windows negotiation, all endpoints can be reached by telnet from each server. Mirrorring works. So far so good.
But one of these partners is not able to connect to the witness. The witness' error log is full with that:
"2006-06-01 13:45:20.32 Logon Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(Der Anmeldeversuch ist fehlgeschlagen.). State 67.'. [CLIENT: 130.143.205.54]"
My Endpoints are created like
CREATEENDPOINT [EASYRIS_Mirroring]
AUTHORIZATION [code1\dephbrsaa1-sys108]
STATE=STARTED
AS TCP(LISTENER_PORT= 5022, LISTENER_IP=ALL)
FOR DATA_MIRRORING(ROLE= PARTNER, AUTHENTICATION= WINDOWSNEGOTIATE,
ENCRYPTION= SUPPORTED ALGORITHM RC4);What catches my eyes is that
GRANT CONNECTONENDPOINT::EASYRIS_MirroringTO [code1\dephbrsaa1-sys108];
doesn't cause these user to appear in the result set of
SELECT
EP.name, SP.STATE, CONVERT(nvarchar(38),suser_name(SP.grantor_principal_id)) AS GRANTOR,SP
.TYPEAS PERMISSION, CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id)) AS GRANTEE FROMsys.server_permissions SP,sys.endpoints EP WHERE SP.major_id= EP.endpoint_id ORDERBY Permission,grantor, grantee;By the way, these mentioned user is sysadmin and grantor.
Has anyone an idea?
Torsten
