locked
data mirroring RRS feed

  • Question

  • Configuring Endpoints

    - Configuring endpoint on principal server(RAJU\RAMESH) (Success)

    - Configuring endpoint on mirror server(RAJU\KITTU) (Success)

    this is the report i ot when i conf data mirroring in sql 2005, but the error what i get is
    TITLE: Database Properties
    ------------------------------

    One or more of the server network addresses lacks a fully qualified domain name (FQDN).  Specify the FQDN for each server, and click Start Mirroring again.

    The syntax for a fully-qualified TCP address is:
    TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>

    ------------------------------
    BUTTONS:

    OK
    ------------------------------
     plz sggest me
    Monday, February 8, 2010 2:11 AM

Answers

  • I see that you are trying to configure mirroring in the same machine that has two instances - if that is the case i am sure that you might have two different port numbers that your SQL servers listens , so please include them in the server name as well.
    When configuring mirroring , try connecting to both your principal and mirrored instance with the format raju\kittu,xxxx and raju\ramesh,xxxx


    Thanks, Leks
    Monday, February 8, 2010 3:15 AM
    Answerer

All replies