locked
mirroring issue on sql server 2008 R2 RRS feed

  • Question

  • TITLE: Database Properties
    ------------------------------

    One or more of the server network addresses lacks a fully qualified domain name (FQDN). To start mirroring without using a FQDN, click "Yes." To specify the FQDN, click "No." Then, specify every TCP address by using the syntax for a fully qualified TCP address, and click Start Mirroring again.

    This syntax is:
    TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>

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

    &Yes
    &No
    ------------------------------
    Wednesday, December 31, 2014 12:55 PM

Answers

  • Hi shravankumarkulkarni,

    According to your description, you fail to configure database mirroring. To troubleshoot this issue, please check one of the following methods.

    1. If the servers are in a domain environment.
        a. Find the fully qualified computer name (FQDN) of each server by running 'IPCONFIG /ALL' from the command prompt.      
        b. Concatenate the “Host Name” and “Primary DNS Suffix”.
             Host Name . . . . . . . . . . . . : A
             Primary Dns Suffix . . . . . . . : corp.mycompany.com
             Then FQDN of your computer name is just A.corp.mycompany.com.
        c. Configure database mirroring again.

    2. However, if the servers are not in a domain environment, follow the steps below to setup DNS suffix. Or you can choose to create a FQDN for each server by editing the host file.
        a. Open the server properties window (right click My Computer and then properties)
        b. Click Computer Name tab and then click the 'Change' button
        c. Click 'More' button
        d. Input the 'Primary DNS suffix of this computer'
        f. Click 'OK' & restart the server. For more details, please review this blog.
            
       


    Thanks,
    Lydia Zhang

                                                                                                                                                                  



    Thursday, January 1, 2015 6:32 AM

All replies

  • Have you tried using TCP address? As error says that there is problem with FQDN so its better to try with TCP address if you dont want to solve problem with FQDN.

    Regards,
    Vishal Patel
    Blog: http://vspatel.co.uk
    Site: http://lehrity.com

    Wednesday, December 31, 2014 1:46 PM
  • Hi shravankumarkulkarni,

    According to your description, you fail to configure database mirroring. To troubleshoot this issue, please check one of the following methods.

    1. If the servers are in a domain environment.
        a. Find the fully qualified computer name (FQDN) of each server by running 'IPCONFIG /ALL' from the command prompt.      
        b. Concatenate the “Host Name” and “Primary DNS Suffix”.
             Host Name . . . . . . . . . . . . : A
             Primary Dns Suffix . . . . . . . : corp.mycompany.com
             Then FQDN of your computer name is just A.corp.mycompany.com.
        c. Configure database mirroring again.

    2. However, if the servers are not in a domain environment, follow the steps below to setup DNS suffix. Or you can choose to create a FQDN for each server by editing the host file.
        a. Open the server properties window (right click My Computer and then properties)
        b. Click Computer Name tab and then click the 'Change' button
        c. Click 'More' button
        d. Input the 'Primary DNS suffix of this computer'
        f. Click 'OK' & restart the server. For more details, please review this blog.
            
       


    Thanks,
    Lydia Zhang

                                                                                                                                                                  



    Thursday, January 1, 2015 6:32 AM