Post reply

Error when I click on "Start Mirroring" button.

  • May 26, 2009 at 1:55 am

    #205270

    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.

  • May 26, 2009 at 2:05 am

    #999739

    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.

    [font="Verdana"]Markus Bohse[/font]

  • May 26, 2009 at 2:54 am

    #999759

    I was configuring mirroring on my TEST servers.

    No, both are different servers and NOT same.

  • May 26, 2009 at 3:24 pm

    #1000225

    have you created proper tcp endpoints ?

  • May 26, 2009 at 11:33 pm

    #1000346

    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.

  • May 27, 2009 at 10:52 am

    #1000832

    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.

  • May 28, 2009 at 3:08 am

    #1001266

    Thanks, I will check and revert back.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply