Tags

, , ,

Hello Everyone,

While I was installing the SQL Server 2016 Failover Cluster Instance on a first node of cluster DB, I faced the following permission error:

The cluster resource ‘SQL Server’ could not be brought online due to an error bringing the dependency resource ‘SQL Network Name’ online

 

SQL Error1

As suggested, to investigate on the detailed error list I opened the Cluster Events in the Failover Cluster Manager and found:

Error: Cluster network name resource failed to create its associated computer object in domain.

Error Code: Access is denied.

 

SQL Error2

 

Resolution:

The error occurred because the permission “Create Computer Object” and “Read all properties” has not been granted to the Cluster Name Object (CNO).

  1. Kindly follow the steps provided under Resolutions -> Option #1 in the MSDN article below:

https://blogs.msdn.microsoft.com/psssql/2013/09/30/error-during-installation-of-an-sql-server-failover-cluster-instance/

2. Also need to provide the account for person who install the cluster, the permissions “Create Computer Object” and “Read all properties” as mentioned in the document below:

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc731002(v=ws.10)#to-configure-the-account-for-the-person-who-installs-the-cluster

 

Once the permissions were updated, I clicked on the Retry button and the Installation continued and completed successfully.

While browsing for issues I came across this detailed MS doc on the Event ID – 1194.  Hope this will be helpful to someone.

Thanks ! 😀