Solved

Failover Cluster issues

Posted on 2012-03-28
5
5,498 Views
Last Modified: 2012-04-17
Getting errors in Failover cluster manager,
also shows resource online (Name resolution Not yet Available)

Here are some events, need help fixing issue


Log Name:      System
Source:        Microsoft-Windows-FailoverClustering
Date:          3/27/2012 4:12:59 PM
Event ID:      1196
Task Category: Network Name Resource
Level:         Error
Keywords:      
User:          SYSTEM
Computer:      server.domain.com
Description:
Cluster network name resource 'ORSQLDB' failed registration of one or more associated DNS name(s) for the following reason:
DNS RR set that ought not exist, does exist.
.

Ensure that the network adapters associated with dependent IP address resources are configured with at least one accessible DNS server.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
    <EventID>1196</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>19</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime="2012-03-27T20:12:59.076339500Z" />
    <EventRecordID>62300</EventRecordID>
    <Correlation />
    <Execution ProcessID="2096" ThreadID="6296" />
    <Channel>System</Channel>
    <Computer>server.domain.com</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData>
    <Data Name="ResourceName">ORSQLDB</Data>
    <Data Name="StatusString">DNS RR set that ought not exist, does exist.
</Data>
  </EventData>
</Event>

Log Name:      System
Source:        Microsoft-Windows-FailoverClustering
Date:          3/27/2012 4:12:59 PM
Event ID:      1579
Task Category: Network Name Resource
Level:         Warning
Keywords:      
User:          SYSTEM
Computer:      server.domain.com
Description:
Cluster network name resource 'ORSQLDB' failed to update the DNS record for name 'ORSQLDB.domain.com' over adapter 'Local Area Connection'. The error code was 'DNS RR set that ought not exist, does exist. (9007)'. Ensure that a DNS server is accessible from this cluster node and contact your DNS server administrator to verify the cluster identity can update the DNS record 'ORSQLDB.domain.com'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
    <EventID>1579</EventID>
    <Version>0</Version>
    <Level>3</Level>
    <Task>19</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8000000000000000</Keywords>
    <TimeCreated SystemTime="2012-03-27T20:12:59.067549200Z" />
    <EventRecordID>62299</EventRecordID>
    <Correlation />
    <Execution ProcessID="2096" ThreadID="6296" />
    <Channel>System</Channel>
    <Computer>server.domain.com</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData>
    <Data Name="ResourceName">ORSQLDB</Data>
    <Data Name="DnsName">ORSQLDB.domain.com</Data>
    <Data Name="Status">DNS RR set that ought not exist, does exist. (9007)</Data>
    <Data Name="AdapterName">Local Area Connection</Data>
    <Data Name="IP Address">1.2.3.4</Data>
    <Data Name="BinaryParameterLength">4</Data>
    <Data Name="BinaryData">2F230000</Data>
  </EventData>
</Event>
0
Comment
Question by:Indyrb
  • 3
  • 2
5 Comments
 
LVL 33

Expert Comment

by:paulmacd
ID: 37777808
If the server is dual-homed, try disconnecting one of the network connections.

I presume the server(s) can see their DNS server?
0
 

Author Comment

by:Indyrb
ID: 37779411
Yes the server is dual homed,

(1) nic for the private heartbeat
And one nic for the production Lan
0
 
LVL 33

Expert Comment

by:paulmacd
ID: 37781796
Make sure the Production NIC has priority and that the Heartbeat NIC isn't set up to use DNS/DHCP.
0
 

Accepted Solution

by:
Indyrb earned 0 total points
ID: 37838014
I found the issue, there was a CNAME record pointing to wrong IP address.
0
 

Author Closing Comment

by:Indyrb
ID: 37854916
found issue on my own
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now