"
2006-11-10 11:54:47.28 Logon
Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed
with error: 'Connection
handshake failed. The login 'NT
AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint.
State 84.'. [CLIENT: 10.77.100.86]"
Anybody knows the solution for the same please let me know
Hi,
What is login account your SQL Server start?
Account is the same in both?
Regards,
|||Account is the same in both the SQL servers.|||I would suggest delete both endpoints in both servers
re-run the Mirror Wizard, give it the AD domain username again, and it'll create the endpoints for you
or it probably uses the authentication you're using when you create the mirror
or try this
/****** Object: Endpoint [Mirroring] Script Date: 11/13/2006 10:31:45 ******/
CREATE ENDPOINT [Mirroring]
AUTHORIZATION [DOMAIN\username]
STATE=STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = DISABLED)
No comments:
Post a Comment