Need a Help in Mirroring

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  September 1, 2010 at 6:11 am

  #237505

  Dear Experts,

  I am trying to mirroring the database bewteen two server, I have followed all steps with Microsoft BOL,

  But when i starts the Mirroring I got this issues , i tried multiple attemt but I cant Please Help me,

  In My principal server while i start Mirror

  The server network address "TCP://NABONIDUS.infrasoftcorp.com:5022" can not be reached

  or does not exist. Check the network address name and that the ports for the

  local and remote endpoints are operational. SQL Server 2008 - 1418.

  Suddenly I received In Mirrored server Event Log this Error

  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.20.1.5]

  Thanks In advance

• Big Data Man

  SSCrazy Eights

  Points: 8536

  More actions

  September 1, 2010 at 6:34 am

  #1214902

  Saravanan_tvr (9/1/2010)

  ---

  Dear Experts,

  I am trying to mirroring the database bewteen two server, I have followed all steps with Microsoft BOL,

  But when i starts the Mirroring I got this issues , i tried multiple attemt but I cant Please Help me,

  In My principal server while i start Mirror

  The server network address "TCP://NABONIDUS.infrasoftcorp.com:5022" can not be reached

  or does not exist. Check the network address name and that the ports for the

  local and remote endpoints are operational. SQL Server 2008 - 1418.

  Suddenly I received In Mirrored server Event Log this Error

  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.20.1.5]

  Thanks In advance

  Sounds like you are using non-domain accounts for SQL Server service, thus will need to grant the machine account Connect permissino on the end points. This will need to be done on both servers and once completed, everything should work.

  Here is a sample script:

  ON MIRROR:

  CREATE LOGIN [INTERNAL\PRINCIPAL_MACHINE$]

  FROM WINDOWS WITH DEFAULT_DATABASE=[master],

  DEFAULT_LANGUAGE=[us_english]

  GRANT CONNECT ON ENDPOINT::Mirroring TO [INTERNAL\PRINCIPAL_MACHINE_ACCOUNT$]

  --------------------------------------------------------------------------

  ON PRINCIPAL:

  CREATE LOGIN [INTERNAL\MIRROR_MACHINE_ACCOUNT$]

  FROM WINDOWS WITH DEFAULT_DATABASE=[master],

  DEFAULT_LANGUAGE=[us_english]

  GRANT CONNECT ON ENDPOINT::Mirroring TO [INTERNAL\MIRROR_MACHINE$]

  Hope this helps.

  Phillip Cox

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  September 1, 2010 at 9:11 am

  #1215070

  Hi Cox

  Thanks for your valuable suggestions.

  I would like to clarify some necessary informations for the below reported issue in the implementation of Database Mirroring

  in our network,

  Both the servers (Principal and Mirror) were in the Same Domain Environment and the accounts used to connect both the servers had full domain user rights for SQL Server Service.

  Now after executing your sample script, we are getting the error message in the principal server as like below,

  Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (80090322) 0x80090322(The target principal name is incorrect.). State 66.

  Previously we were getting the same type of error message in the Mirror Server as below,

  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.

  Still we are facing the issues in the implementation of Database Mirroring error (SQL Server Error Code - 1418).

  Thanks in Advance

• Big Data Man

  SSCrazy Eights

  Points: 8536

  More actions

  September 2, 2010 at 4:56 am

  #1215502

  Saravanan_tvr (9/1/2010)

  ---

  Hi Cox

  Thanks for your valuable suggestions.

  I would like to clarify some necessary informations for the below reported issue in the implementation of Database Mirroring

  in our network,

  Both the servers (Principal and Mirror) were in the Same Domain Environment and the accounts used to connect both the servers had full domain user rights for SQL Server Service.

  Now after executing your sample script, we are getting the error message in the principal server as like below,

  Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (80090322) 0x80090322(The target principal name is incorrect.). State 66.

  Previously we were getting the same type of error message in the Mirror Server as below,

  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.

  Still we are facing the issues in the implementation of Database Mirroring error (SQL Server Error Code - 1418).

  Thanks in Advance

  Hi,

  OK, when you configured database mirroring, did you specify the SQL Server domain service accounts to use? If not, you will need to grant the service accounts CONNECT to the endpoints on both servers.

  The scripts were just samples and you would need to adjust to meet your environment needs, but since you are using domain based accounts, just update endpoint connect permissions.

  Please let me know.

  Phillip Cox