3

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.

Improve this question
8
  • 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
    Commented Sep 9, 2013 at 7:14
  • yes am using FQDN and End points are configured properly.
    – user2315732
    Commented Sep 9, 2013 at 7:26
  • For your info am not able to use Telnet from my servers
    – user2315732
    Commented Sep 9, 2013 at 7:27
  • is it giving u error ?
    – Kin Shah
    Commented Sep 9, 2013 at 9:49
  • Gives me that Telnet is not recognized as internatl or external command,operable program or batch file
    – user2315732
    Commented Sep 9, 2013 at 10:48

1 Answer 1

Reset to default
2

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];
GO
Improve this answer
4
  • 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
    – user2315732
    Commented Sep 10, 2013 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
    Commented Sep 11, 2013 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?
    – user2315732
    Commented Sep 17, 2013 at 5:35
  • technet.microsoft.com/en-us/library/ms189852.aspx Check out the overview.
    – Raadee
    Commented Sep 17, 2013 at 13:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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