Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

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

1 Answer

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
share|improve this answer
    
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 Sep 10 '13 at 6:00
    
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? –  user2315732 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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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