none
error while doing mirroring RRS feed

  • Frage

  • I got the following error log from SQL profiler when I tried to start mirroring

    "

    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

    Freitag, 10. November 2006 06:38

Alle Antworten

  • Hi,

    What is login account your SQL Server start?

    Account is the same in both?

    Regards,

    Freitag, 10. November 2006 18:13
  • Account is the same in both the SQL servers.
    Montag, 13. November 2006 03:52
  • 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)

    Montag, 13. November 2006 15:32