SQL Server Performance Forum – Threads Archive
NT AUTHORITYANONYMOUS LOGONHi 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]
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,
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.
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.