Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error when I click on "Start Mirroring" button. Expand / Collapse
Author
Message
Posted Tuesday, May 26, 2009 1:55 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
Dear All,

I was configuring mirroring on my TEST servers. I could configure it succesfully (I din't configure witness server at all).But when I click on "Start Mirroring" it gives me the following error.

"TCP://MIRROR_servername:5022" can not be reached or does not exist.Check the network address name and reissue the command.(Microsoft SQL server, Error:1418)"

First it was caoming for principal server("TCP://PRINCIPAL_servername:5022") . Then I made the mirror database in NO RECOVERY mode.After that this error is coming for MIRROR SERVER.

What to do..? Pls help..
And is it essential to configure witness server..?


Thanks in advance.
Post #723067
Posted Tuesday, May 26, 2009 2:05 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 4,432, Visits: 4,156
You say you configured this on your test server. Does that mean that the principal and the mirror databases are both on the same server? If that's the case you cannot use port 5022 for both endpoints. Change one of them to 5023 or any other free port.

Markus Bohse
Post #723070
Posted Tuesday, May 26, 2009 2:54 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
I was configuring mirroring on my TEST servers.


No, both are different servers and NOT same.




Post #723100
Posted Tuesday, May 26, 2009 3:24 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, March 30, 2014 10:24 PM
Points: 673, Visits: 556
have you created proper tcp endpoints ?
Post #723650
Posted Tuesday, May 26, 2009 11:33 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
shahm10 (5/26/2009)
have you created proper tcp endpoints ?


There's a small problem infact. I created it using SSMS wizard. So for Principal it's coming as "TCP://principalservername.domainname:5022"
but for Mirror "domainnam is not coming"..only "TCP://mirrorservername:5022" is coming.
Why so.? Using wizard it's streight forward anyways. Nothing complicated.
But Where am I doing wrong ?. Can u just brief how to create "TCP ENDPOINTS" properly.?

Thanks.
Post #723795
Posted Wednesday, May 27, 2009 10:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, March 30, 2014 10:24 PM
Points: 673, Visits: 556
Create TCP endpoints using T-SQL statements and then grant CONNECT permissions to your login on both principal and mirror servers.

CREATE ENDPOINT [Mirroring]
STATE=STARTED
AS TCP (LISTENER_PORT=1430,LISTENER_IP=ALL)
FOR DATA_MIRRORING (ROLE=PARTNER,AUTHENTICATION=WINDOWS NEGOTIATE,ENCRYPTION=REQUIRED ALGORITHM RC4)

Create endpoint on both servers and then grant permissions and then use wizard.
Post #724357
Posted Thursday, May 28, 2009 3:08 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
Thanks, I will check and revert back.
Post #724874
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse