?
Solved

SQL Cluster Went Down "Cluster network name resource " can be brought online

Posted on 2009-02-14
4
Medium Priority
?
2,503 Views
Last Modified: 2012-05-06
Dears
Good Day

I did failover yesterday for our SQL 2005 server cluster hosted on 2008 64-bit and I got the below error:
"
Cluster network name resource 'SQL Network Name (RUH-003-SQL-01)' cannot be brought online. The computer object associated with the resource could not be updated in domain 'prod.mobily.lan' for the following reason:
Unable to find computer account on DC where it was created.

The text for the associated error code is: There is no such object on the server.

 
The cluster identity 'RUH-003-CL-001$' may lack permissions required to update the object. Please work with your domain administrator to ensure that the cluster identity can update computer objects in the domain."

I opened a case with Microsoft and they resotred the object but stiil the same event is coming
Our Production SQL is down now. pleaaaaaaaase help

Thanks
0
Comment
Question by:MOSS_Lover
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 23645212
did you do any changes in your DSN\AD?

Any changes on your cluster server?
what "object " MS restored?

--------------

-----------------------------------------------------------------------
start:
Cluster network name may not come online with Event ID 1052

http://support.microsoft.com/kb/257903/
continue read:

Description of the properties of the cluster Network Name resource in Windows Server 2003
http://support.microsoft.com/kb/302389

----------------------------------------------------------------
Active Directory access rights for creating a computer object
How to troubleshoot the Cluster service account when it modifies computer objects
http://support.microsoft.com/kb/307532/

0
 

Accepted Solution

by:
MOSS_Lover earned 0 total points
ID: 23652146
This is how Microsoft solved:

1)      Run ldp from run or go to tools folder: C:\Program Files\SupportTools
2)      Connection à Connect à DNS Host Name à Bind à username & password & domain
3)      View à Tree
4)      Options à Controls à Object Identifier = 1.2.840.113556.1.4.417 à Check In à OK
5)      Double click DC=prod,DC=bb,DC=lan 2 times
6)      Double click CN=Deleted Objects,DC=prod,DC=bb,DC=lan
7)      Ctrl +N
8)      Double click the deleted object à right click à modify
9)      Insert isDeleted to the attribute filed à chose delete choice à click enter
10)       Insert distinguishedName to the attribute filed à
11)       On the ritght pain look for lastKnownParent:  and copy the text after is. E.g: OU=All Users,DC=prod,DC=bb,DC=lan
12)       On Modify Box Valu add DN name. e.g CN=Abdalla O. Omer + , + what you copied from step 10. so you will set: CN=Abdalla O. Omer,OU=All Users,DC=prod,DC=bb,DC=lan
13)       chose Replace choice à click enter
14)       Check Synchounce & Extended checkboxes
15)       Click Run

then we repaird AD network cluster
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 23655908
Hmm..

did they say what could be  a reason of the problem?
and how did you ' repaird AD network cluster"?

---
looks like the record was deleted  from DNS\AD...


0
 
LVL 1

Expert Comment

by:andrelmx
ID: 35819812
I'm having the same error here, but sincerily It`s not clear what has been done on this solution. What was wrong?

It's the same case of mine, but it`s not clear.

MOSS_Lover, could you put here the description of Microsoft about the problem?

Thank you.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Viewers will learn how the fundamental information of how to create a table.

850 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