SQL Server Performance

NT AUTHORITYANONYMOUS LOGON

Discussion in 'SQL Server 2005 Database Mirroring' started by aikimare, Jun 11, 2007.

  1. aikimare New Member

    Hi all,

    I have problem with connecting to endpoint on mirror server. I made endpoints with windows (domain user), but in log file viewer I got message:
    "Database Mirroring login attempt by user 'NT AUTHORITYANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITYANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84"

    I know...I must use domain users...where can I select them. My endpoints look like:
    CREATE ENDPOINT [Mirroring]
    AUTHORIZATION [VODAadministrator]
    STATE=STARTED
    AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
    FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE
    , ENCRYPTION = DISABLED)

    Where is my mistake? Whitch service (SQL server) in Services (locar) must run on domain users?

    Thank you a lot,
    Marko

  2. satya Moderator

    Are you using domain account for SQL server services?
    You must use DOMAIN account for such endpoints authentication.
    Also this SQL Server message indicates that the server network address cannot be reached or does not exist, and it suggests that you check the network address name and reissue the command.http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14871 fyi.


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page