Tuesday 28 June 2016

SQL Server Cluster Network Name Resource ‘SQL Network Name’ Failed Issue

Issue
Today will discuss about the issue that I’ve encountered during performing an installation of a SQL Server failover cluster is “The cluster resource ‘SQL Server (MSSQLSERVER)’ could not be brought online due to an error bringing the dependency resource ‘SQL Network Name (MSSQL2012)’ online.” Upon checking the cluster events in the Failover Cluster Manager, you will find the below error.


Cluster network name resource 'SQL Network Name (MSSQL2012)' failed to create its associated computer object in domain 'ENTERPRISE.ORG' for the following reason: Resource online. The associated error code is: -1073741790 Please work with your domain administrator to ensure that: - The cluster identity 'WIN2012$' can create computer objects. By default, all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed. - The quota for computer objects has not been reached. - If there is an existing computer object, verify the Cluster Identity ' WIN2012$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
Lets first understand, what is Cluster Name Object (CNO)?
In a Windows Server Failover Cluster, a cluster name object (CNO) is an Active Directory (AD) account for a failover cluster.

A CNO is automatically created during cluster Setup. When the administrator creates a failover cluster and configures clustered services or applications, the "Create Cluster Wizard" creates all the Active Directory computer accounts the failover cluster requires and gives each account specific permissions. The wizard also creates a computer account for the failover cluster itself; this account is called the cluster name object.

The CNO is important because other accounts are created through it. If the CNO is deleted or permissions for the account are changed, other computer accounts required by the cluster can't be created until the CNO and correct permissions are restored.

Beginning with Windows Server 2012, both the Create Cluster Wizard and the PowerShell cmdlet New-Cluster allow administrators to decide which organizational unit (OU) should contain the CNO.

There are basically two solution of this problem:

1. One resolution is a preventative action that can be done prior to beginning the installation of the SQL Server Failover Cluster, and
2. Second resolution is after the issue experienced during installation to be able to continue.
Both resolutions require access and permissions to AD.

Resolution
1. The resolution that will prevent this issue on future installations is to “pre-stage” the VCO.

- Log in as a user with permissions to create computer objects in the domain.
- Under Active Directory Users and Computers, create a “New Computer” object within the desired AD Container for the VCO (this will be your SQL Server Network Name).
- Once the object has been created, you can then add the CNO (this will be your WSFC Name) to the security of the VCO with “Full Control” over the VCO.

2. To achieve the resolution that will be reactive for your current errors, you need to grant the proper permissions to the CNO.

- Log in as a user with administrative permissions in the domain.
- Under Active Directory Users and Computers, grant the CNO (this will be your WSFC Name) “Create Computer Objects” permissions.

After doing this, you can retry your previously failed installation, and it should be successful. To verify if this issue was corrected, you can navigate within the SQL Server (MSSQLSERVER) Cluster group and attempt to bring the Server Name resource online.
If the resource is able to be brought online successfully and thats it!!

17 comments:

  1. Hello, yeah this article is truly good and I have learned lot of things from it on the
    topic of blogging. thanks.

    ReplyDelete
  2. Wonderful goods from you, man. I've understand your stuff previous to and you are just extremely
    magnificent. I really like what you have acquired here, really like what you're stating and the way in which you say it.
    You make it enjoyable and you still care for to keep it
    smart. I can't wait to read far more from you. This is actually a great website.

    ReplyDelete
  3. I visit every day some web sites and websites to read articles or reviews, however this weblog gives
    quality based writing.

    ReplyDelete
  4. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on. SQL server dba Online Training

    ReplyDelete
  5. We absolutely love your blog and find a lot of your post's to be exactly what I'm looking for.

    Do you offer guest writers to write content for yourself?
    I wouldn't mind composing a post or elaborating on a number of the subjects you write about here.
    Again, awesome blog!

    ReplyDelete
  6. Hi, I do believe this is an excellent site. I stumbledupon it ;) I'm going to come
    back yet again since i have saved as a favorite it.
    Money and freedom is the best way to change, may you be rich and continue to
    guide other people.

    ReplyDelete
  7. I have read so many articles or reviews on the topic of the blogger lovers but this piece of writing
    is really a nice paragraph, keep it up.

    ReplyDelete
  8. Nice blog here! Also your web site loads up fast! What web host are you using?
    Can I get your affiliate link to your host? I wish my web site loaded up as
    quickly as yours lol

    ReplyDelete
  9. Please let me know if you're looking for a article author
    for your weblog. You have some really great posts and I believe I would be a good asset.

    If you ever want to take some of the load off, I'd absolutely love to
    write some material for your blog in exchange for a link back to mine.

    Please blast me an email if interested. Thanks!

    ReplyDelete
  10. Hello there! This article couldn't be written much better!

    Reading through this post reminds me of my previous roommate!
    He continually kept preaching about this. I am going to forward this article to him.
    Fairly certain he's going to have a very good read.
    Thank you for sharing!

    ReplyDelete
  11. I have been surfing online more than 3 hours lately, yet I by no means discovered any attention-grabbing
    article like yours. It's lovely price enough for me. In my opinion, if all site owners and bloggers made good
    content material as you did, the net shall be a lot more helpful than ever before.

    ReplyDelete
  12. When some one searches for his required thing, thus he/she wishes to
    be available that in detail, thus that thing is maintained over here.

    ReplyDelete
  13. Hi would you mind letting me know which hosting
    company you're utilizing? I've loaded your blog in 3 completely different browsers and I must
    say this blog loads a lot faster then most. Can you suggest a good hosting provider at a honest price?

    Cheers, I appreciate it!

    ReplyDelete
  14. If you want to get a good deal from this piece of writing then you have to apply these strategies to your won webpage.

    ReplyDelete
  15. Good day! Do you know if they make any plugins to assist with Search Engine Optimization? I'm trying
    to get my blog to rank for some targeted keywords but I'm not seeing
    very good results. If you know of any please share. Many thanks!

    ReplyDelete
  16. Incredible quest there. What happened after? Good luck!

    ReplyDelete
  17. You should take part in a contest for one of the finest sites online.
    I most certainly will recommend this web site!

    ReplyDelete