?
SolvedPrivate

DNS Operation refused event every 15 Minutes

Posted on 2014-01-14
4
Medium Priority
?
67 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 2000 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 60

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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

752 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