locked
Mirror error 1418 (in principal server sql error log - :DNS lookup failed with error: '11004 RRS feed

  • Question

  • Task- Mirroring between DC and DR. DC servers are in failover clustering having Virtual IP

    xxx.xxx.xx.34. DR server is running on standalone  server with IP xx.xxx.xx.73.DC&DR servers are in trusted domain having different subnet.

    1.        SQL Servers are installed with same service account (domain account  abc\admin) on DC &DR Site.
    2.        Mirrored DB is restored with no recovery having latest full &transaction backup.
    3.         port is used 3399. Opened this port on both side on firewall.
    4.        Telnet is successfully executed from DC to DR and vice versa. On DC IP xxx.xxx.xx.34 (Virtual cluster IP).
    5.        Endpoints are created on both side.
    6.        But when configuring mirroring .error 1418 is occurred.
    7.        Seen in sql log error in principal server :- ERROR :DNS lookup failed with error: '11004(The requested name is valid<c/> but no data of the requested type was found.)
    8.        Checked DNS ,itz working ok.
    9.        There is no error generating in SQL log of Mirror server.
    10. done for grant permission for endpoint 

    --GRANT CONNECT on ENDPOINT::Mirroring TO public; on both principal and mirror server.



    @Please help.

        


    Regards Naveen 


    • Edited by Naveen-DBA Tuesday, May 13, 2014 7:18 AM update
    Sunday, May 11, 2014 1:54 PM

Answers

  • Hi all,

    Mirroring Has Done Successfully.
    >> Reason of error - Principal & mirror servers were able to telnet each other through server name and Static IP addresses.But telnet were not executed with FQDN.  
    Solution :- FQDN address have added in hosts file on principal and mirror servers.

    Now Mirroring is done ..............


    Regards Naveen MSSQL DBA

    • Proposed as answer by Shanky_621MVP Wednesday, May 14, 2014 12:30 PM
    • Marked as answer by Naveen-DBA Sunday, May 18, 2014 1:50 PM
    Wednesday, May 14, 2014 12:16 PM

All replies

  • HI 

    Please find below link 

    http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring

    and also

    http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

    --------

    If u find it helpful please Mark as Answer/Helpful

    • Proposed as answer by Sofiya Li Monday, May 12, 2014 8:29 AM
    Monday, May 12, 2014 4:44 AM
  • Hi,

    Microsoft has created a Nice article about how to go on troubleshooting 1418 error.Please help your self

    http://technet.microsoft.com/en-us/library/ms189127.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    My TechNet Wiki Articles

    Monday, May 12, 2014 10:22 AM
  • had read all articles in KB but none of them could resolve my problem.

     

    Regards Naveen MSSQL DBA

    Tuesday, May 13, 2014 7:14 AM
  • had read all articles in KB but none of them could resolve my problem.

    Error 1418 can have many reasons, it also depends on how much efficient you are with mirroring and troubleshooting. I guess you are missing some thing.

    Are you giving correct name for the partner server, please involve AD tem to look at DNS error


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    My TechNet Wiki Articles


    Tuesday, May 13, 2014 8:20 AM
  • Thanx shanky for ur valuable comments..

    But there is no error in DNS . nslookup is resolving dns servers at DC and DR servers accordingly.

    You r right that we are missing something. Thats what i need to know.

     


    Regards Naveen MSSQL DBA

    Tuesday, May 13, 2014 4:36 PM
  • Hi all,

    Mirroring Has Done Successfully.
    >> Reason of error - Principal & mirror servers were able to telnet each other through server name and Static IP addresses.But telnet were not executed with FQDN.  
    Solution :- FQDN address have added in hosts file on principal and mirror servers.

    Now Mirroring is done ..............


    Regards Naveen MSSQL DBA

    • Proposed as answer by Shanky_621MVP Wednesday, May 14, 2014 12:30 PM
    • Marked as answer by Naveen-DBA Sunday, May 18, 2014 1:50 PM
    Wednesday, May 14, 2014 12:16 PM