Failover Cluster SQL Network Name "Online (Name Resolution Not Yet Available)"

  • Hi,

    I have several SQL 2008 Failover Clusters configured on Windows 2008 R2. Over the weekend something unknown happened, and now the SQL Network Name is reporting "Online (Name Resolution Not Yet Available)".

    Everything seems to be working fine except that note is bugging me. Google came up empty. Any ideas?

  • If you see this thread could you please go to my MS Connect request and vote it up?

    https://connect.microsoft.com/SQLServer/feedback/details/674454/name-resolution-not-yet-available

  • Cluster Log

    000015a0.00001cac::2011/06/07-19:04:59.218 INFO [RES] Network Name <SQL Network Name (XXX)>: adapter Public (2)

    000015a0.00001cac::2011/06/07-19:05:02.823 INFO [RES] Network Name <SQL Network Name (XXX)>: [cxl::Pinger-"XXX"] Host registered, but no records of type 23

    000015a0.00001cac::2011/06/07-19:05:02.823 WARN [RES] Network Name <SQL Network Name (XXX)>: [cxl::Pinger-"XXX"] Could not find any endpoints for remote target

    000015a0.00001cac::2011/06/07-19:05:02.823 WARN [RES] Network Name <SQL Network Name (XXX)>: WaitForTargetToComeUp: Found registered IPs that are not providers: xxx.xxx.xxx.xxx

    000015a0.00001cac::2011/06/07-19:05:06.426 INFO [RES] Network Name <SQL Network Name (XXX)>: [cxl::Pinger-"XXX"] Host registered, but no records of type 23

    000015a0.00001cac::2011/06/07-19:05:06.426 WARN [RES] Network Name <SQL Network Name (XXX)>: [cxl::Pinger-"XXX"] Could not find any endpoints for remote target

    000015a0.00001cac::2011/06/07-19:05:06.427 INFO [RES] Network Name <SQL Network Name (XXX)>: Setting resource specific message to <Name Resolution Not Yet Available>.

  • Looks like my issue was a bad hosts file entry...check yours...

  • SQLName same machine exist on the network ?

    can you ping IP address of this SQLName ?

    can you ping any DNS name in the network ?

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • in your domain, the dns server is running?


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Jon.Morisi (6/7/2011)


    Looks like my issue was a bad hosts file entry...check yours...

    why on earth are you using hosts file entires and not your DNS zone??

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

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

  • why on earth are you using hosts file entires and not your DNS zone??

    its a commvault backup thing

Viewing 8 posts - 1 through 7 (of 7 total)

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