Post reply

Setup Mirroring - can't edit Pricipal / Mirror network address

  • February 23, 2011 at 11:43 am

    #234059

    Hi all

    When setting up a mirror, on the pricipal server, I go to the DB properties / Mirroring. Just below Principal, Mirror and witness network address area there is a note "Use fully-qualified TCP addresses". SQL puts in the machine names, which I'm trying to change to the IP addresses, but the edit controls are greyed out. I'm unable to change it, as recommended by MSDN: http://msdn.microsoft.com/en-us/library/ms188712.aspx

    I've followed all the other steps in preparation, I just can't get the two servers to connect because I'm unable to enter the address!

    Any help apprecaited.

    Thanks,

    Hein

  • February 23, 2011 at 1:06 pm

    #1290599

    Have you tried to drop the existing end points and recreating with the IP Address...

    Something like:

    CREATE ENDPOINT DB_Mirror

    STATE=STARTED

    AS TCP (LISTENER_PORT=5022,LISTENER_IP=(192.168.253.2))

    FOR DATABASE_MIRRORING (ROLE=PARTNER)

  • February 23, 2011 at 1:18 pm

    #1290607

    Thanks I've dropped the end points to see if I can, then I will re-create.

    I just did not have time to recreate them with Transact SQL. I need to go live tonight, so the mirror will have to wait.

    So weird that I can't edit the server addresses.

  • February 23, 2011 at 3:57 pm

    #1290673

    If the endpoints are created correctly and you just want to initiate mirroring the databases, you can run the following on each database. SSMS validates the FQDN, but the server itself does not.

    ALTER DATABASE xxx SET PARTNER = 'x.x.x.x'

Viewing 4 posts - 1 through 3 (of 3 total)

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