Wednesday, September 30, 2015

The cluster resource 'SQL Server (SQL2014)' could not be brought online due to an error bringing the dependency resource 'SQL Network Name (SQL2014)'


Users will face this common issue during SQL Server Failover Cluster installation. Note that SQL Server Engine service is always dependent on Network Name resource. The network resource failure can result the SQL Server resource not coming online.

User may see below messages in system log

Cluster network name resource 'SQL Network Name (SQL2014)' failed to create its associated computer object in domain sqlserver-expert.com' during: Resource online.

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

Please work with your domain administrator to ensure that:
- The cluster identity 'SQL2014$' has Create Computer Objects permissions. By default all computer
objects are created in the same container as the cluster identity 'SQL2014$'.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'SQL2014$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.

The main cause for this error is insufficient permission to create computer objects. You have two options to resolve this error.

1. Ask your Windows Admin to grant permission “Read all properties” and “Create Computer Objects to the CNO via the container.

Or

2. Ask your Windows Admin to create required computer objects.

You can refer below link for more info

http://blogs.msdn.com/b/psssql/archive/2013/09/30/error-during-installation-of-an-sql-server-failover-cluster-instance.aspx

Regards,
Satishbabu Gunukula

No comments:

Post a Comment