Hello again !

recently i have observed some problems with cluster installation in one of my clients. In server logs were those messages:

Message 1:

"Cluster network name resource SQL Network Name 'XXX' failed to create its associated computer object in domain 'XXX' for the following reason:Unable to update password for computer account.

The text for the associated error code is :Access is denied."

Message 2:

'Cluster network name resource 'XXX' failed to register DNS name 'XXX' over adapter 'XXX'  for the following reason: DNS operation refused.'

Cause:

 

Message 1:

Your Windows Cluster machine account has no permission to update SQL Cluster machine account in AD for password change and etc.

Message 2:

The SQL cluster name resource which has been added to the DNS prior to setup need to be updated by the physical nodes on behalf of the resource record itself.

When the active node owns the resources it want to update the A record in the DNS.

Solution:

 

  1. Go to the DNS manager
  2. Then right Click on SQL Cluster DNS record
  3. Go to Properties
  4. Go to Security Tab
  5. Add Windows Cluster Name (Computer Object name) with Full Control
  6. Then remove the current SQL server installation
  7. Install SQL Server 2008 R2 to cluster again.

 

  1. Go to Active Directory Users and Computers
  2. Then right Click on SQL Cluster Name (Computer Object name)
  3. Go to Properties
  4. Go to Security Tab (if you don't see this option go to MMC console menu>view>advanced features )
  5. Add Windows Cluster Name (Computer Object name) with Full Control
  6. Then remove the current SQL server installation
  7. Install SQL Server 2008 R2 to cluster again.


Hope it helps.

More tips and tricks

Is model db important?
by Michal Tinthofer on 15/02/2012

Few days ago I have been asked for help in process of installation a SCOM. Admins wasn’t been able to install some parts of this system because installation wizards reports some unexpected errors. When I arrived to the SQL instance I found something inte

Read more
How to check multiple backups stored in one file
by Michal Tinthofer on 26/06/2012

Backup device is a standard backup file. But this file is registered in management studio and often used to store more than one backups from database. There are also some pros and cons in usage compared to standard backups stored in folders and made by ma

Read more
SMT 00.5.70 Released!
by Michal Tinthofer on 17/04/2019

New version of SMT is now available, you can have a look on the summary of changes.

Read more