SQL Server mirroring connection doesnt work
Posted
by
StNickolas
on Stack Overflow
See other posts from Stack Overflow
or by StNickolas
Published on 2012-03-28T04:17:08Z
Indexed on
2012/03/28
5:29 UTC
Read the original article
Hit count: 239
sql-server-2008
|mirroring
I have 2 servers srv-erp1
and srv-erp3
. I made them mirror on each other. All setup is done by lots of tutorials and examples.
But when I call
ALTER DATABASE MIRROR_TEST SET PARTNER = 'TCP://srv-erp3:5022'
It`s response is:
The server network address "TCP://srv-erp3: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.
I go to cmd on srv-erp3
and use netstat -an...
this port is listening.
I go to cmd on srv-erp1
and use telnet srv-erp3 5022...
and its ok to connect.
All firewalls are turned off. The only difference in config of srvrs is that srv-erp1
is on Windows Server 2003 R2 x64, and srv-erp3
is on Windows 2008 R2 x64
What can be the reason of this problem?
Regards, Dmitry.
© Stack Overflow or respective owner