I am configuring database mirroring on SQL Server 2012. After configuration I am getting the following error when attempting to start the mirroring session:

tcp server cannot be reached or does not exist. Check the network address name and the ports for the local and remote are operational.

an Exception occured while executing a Transactional-SQL Statment.

  • Are you using FQDN - fully qualified domain name ? Also, are the end points configured properly? Try the steps mentioned at blog.sqlauthority.com/2010/01/11/…
    – Kin Shah
    Sep 9 '13 at 7:14
  • yes am using FQDN and End points are configured properly. Sep 9 '13 at 7:26
  • For your info am not able to use Telnet from my servers Sep 9 '13 at 7:27
  • is it giving u error ?
    – Kin Shah
    Sep 9 '13 at 9:49
  • Gives me that Telnet is not recognized as internatl or external command,operable program or batch file Sep 9 '13 at 10:48

You should check the error log on both Principal and Mirror server.

One common error is that you run your Database Engine Service with a different accounts on your servers, in that case your need to grant connect permissions to the accounts on respective endpoints.

GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [Mydomain\username4service];
  • Thanks for the reply i even tried giving the permission on EndPoints but even after i am getting the below Error:Database Mirroring login attempt failed with error: 'Connection handshake failed. There is no compatible encryption algorithm. State 22.'. [CLIENT: IP Adress] and if i see my Mirror databse it shows as Mirror,Disconnected/In recovery Sep 10 '13 at 6:00
  • 1
    Have you looked at the Encryption algorithm on both servers, they should be the same. Run: Select * sys.dm_db_mirroring_connections
    – Raadee
    Sep 11 '13 at 6:32
  • Mirroring works fine now after changing End points properly,Need to understand one thing that mirroring will restore data to secondary if there is change in Primary r will it take copy and restore with out checking the data changes in Primary,i mean if there is no change in primary server then it will copy the data to secodary or not? Sep 17 '13 at 5:35
  • technet.microsoft.com/en-us/library/ms189852.aspx Check out the overview.
    – Raadee
    Sep 17 '13 at 13:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.