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
SolvedPrivate

DNS Operation refused event every 15 Minutes

Posted on 2014-01-14
4
48 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

860 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