SolvedPrivate

DNS Operation refused event every 15 Minutes

Posted on 2014-01-14
4
39 Views
Last Modified: 2016-02-18
Hello,

This environment has a three node SQL cluster running Server 2012.  There are also three resources on this cluster:
DTC
OLTP
SSAS

Every 15 minutes I am seeing event ID 1196 recorded for each resource:
(Cluster network name resource '...dtc' (oltp or ssas) failed registration of one or more associated DNS name(s) for the following reason:
DNS operation refused.

Ensure that the network adapters associated with dependent IP address resources are configured with at least one accessible DNS server.)

I have found several articles online regarding this but none have lead to a resolution.  So far I have tried the following:
- Set the DNS permissions for each cluster resource A record so that the resource, SQL service account, cluster node, and cluster accounts have full control.
- Set Authenticated Users to have Write permissions against the A record.
- Verified that the host server has the proper DNS servers configured for the interface team used for the cluster resource.
- Verified connectivity to the DNS servers from the interface listed above.

Any help is greatly appreciated.

Thanks!
0
Comment
Question by:advserver
  • 2
  • 2
4 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39779886
Hi.  I suspect the issue is you are not allowing dynamic registrations but the network card is set to "Register this connection's addresses in DNS."  Open Properties of NIC > IP Properties > Advanced > DNS, uncheck the aforementioned option.
0
 
LVL 4

Author Comment

by:advserver
ID: 39783472
Thanks Kevin.  we did have dynamic registrations enabled so I did not want to just disable it on the nics because there had to be an underlining issue.

After further investigation I found that one of the DC's had a corrupt AD database.   it just so happened that each of the cluster nodes had this DC listed as the first DNS server.  I specified another DC to be the first DNS server and that resolved the errors in event viewer for each node.

Investigating the AD corruption I found that it went back several months so I decommissioned the DC and built a new system as a replacement.

I will still give you the points because of your help but that was not the resolution.

Thanks!
0
 
LVL 4

Author Comment

by:advserver
ID: 39783483
I've requested that this question be closed as follows:

Accepted answer: 0 points for advserver's comment #a39783472
Assisted answer: 500 points for mwvisa1's comment #a39779886

for the following reason:

Please see my note for the resolution.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39785207
I am glad you found it.  In some shops, the dynamic registration is refused at the server on purpose; therefore, I started with that.  However, you are correct to seek a root cause on the DC if there was no explicit intent to refuse registrations.  Again, good find and thank you for sharing with others in case they run into the same situation.

Respectfully yours,

Kevin
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 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

18 Experts available now in Live!

Get 1:1 Help Now