Announcement

Collapse
No announcement yet.

Cluster network name resource '<SQL Network Name>' failed to create its associated

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cluster network name resource '<SQL Network Name>' failed to create its associated

    Cluster network name resource '<SQL Network Name>' failed to create its associated computer object in domain 'xyz.com' for the following reason: Unable to create computer account.
    The text for the associated error code is: Access is denied.

    Here is the summary of steps while installing SQL Server 2005 Cluster on a Windows Server 2008 R2 :

    -- Copy SQL Server 2005 installation files locally on the server and rename CD1 as “SERVER” and CD2 as “TOOLS”
    -- Launch SQL Server 2005 setup exe from SERVER folder.
    -- Select the required features (Database Engine, Intergration Servics and Workstation Components)

    -- After installation, you will find that SQL Server Network Name is not coming online.
    Error :
    Cluster network name resource '<SQL Network Name>' failed to create its associated computer object in domain 'xyz.com' for the following reason: Unable to create computer account.
    The text for the associated error code is: Access is denied.

    -- Go to Active Directory.
    -- Locate the Computer Account – SQL Network Name
    -- Go to the properties of SQL Network Name -> Security
    -- Add Cluster Account and give Full Permissions

    -- Now, you can bring SQL Network name online and SQL Server and SQL Server Agent resources as well.
    -- However, SQL Full Text will still be failing.

    -- Apply SP3 for SQL Server 2005 and Full Text service will be online in Cluster Adminsitrator.

    -- While creating MSDTC resource
    >> Go to Active Directory.
    >> Locate the Computer Account – MSDTC Network Name
    >> Go to the properties of MSDTC Network Name -> Security
    >> Add Cluster Account and give Full Permissions

    Fani T. Kanku
    Sr. Systems Engineer
    MCSE(NT4.0, 2k+2k3); MCSA(2k3); MCTS;MCITP,CCNA; CCA

  • #2
    Re: Cluster network name resource '&lt;SQL Network Name&gt;' failed to create its associate

    This is an old post so it's probably not worth replying to, but I assume that it was put here for informational purposes so I'll throw in my two cents to kill some time.

    Adding the Cluster Name Object (CNO) to the ACL of the SQL Network Name Account in AD will let your SQL resources come online, but I don't think that it addresses the original problem.

    <quote><SQL Network Name>' failed to create its associated computer object in domain 'xyz.com'</quote>

    When Failover Clustering creates your SQL Network Name resource, it attempts to create an account for it in Active Directory (obviously). The reason for this is so that the clustered "virtual server" can support Kerberos authentication.

    The SQL Network Name resource account is created under the security context of the CNO, making the CNO CREATOR OWNER for the SQL Network Name Account in AD (and thereby having Full Control).

    The cause of your original problem, is that your CNO account does not have permission to create computer accounts in the domain. The solution to getting your SQL install to function to begin with instead of having to fix it later is giving your CNO the user rights to add computers to the domain in your Default Domain Controller Policy, preferably via a global group.

    http://support.microsoft.com/kb/947049

    Comment

    Working...
    X