Mirroing to use a different dedicated NIC

  • check which TCP protocols you have bound to the NICs, you will need IPV4

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I have additional 10 GB NICs on each node of the mirror...

    On the principal I used the following to create the end point:

    CREATE ENDPOINT [DB_Mirror]

    AUTHORIZATION [Domain\UserName]

    STATE=STARTED

    AS TCP (LISTENER_PORT = 5030, LISTENER_IP = (192.168.XXX.X))

    FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

    , ENCRYPTION = REQUIRED ALGORITHM RC4)

    GO

    GRANT CONNECT ON ENDPOINT::DB_Mirror TO [domain\sqlserverService account]

    ------------

    Created the end point on the mirror node...

    CREATE ENDPOINT [DB_Mirror]

    AUTHORIZATION [Domain\UserName]

    STATE=STARTED

    AS TCP (LISTENER_PORT = 5030, LISTENER_IP = (192.168.XXX.Y))

    FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE

    , ENCRYPTION = REQUIRED ALGORITHM RC4)

    GO

    GRANT CONNECT ON ENDPOINT::DB_Mirror TO [domain\sqlserverService account]

    If you want the entire document, let me know.

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

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