다음을 통해 공유

SQL Server Troubleshooting: The cluster resource ‘SQL Server’ could not be brought online

  • 아티클

Scenario

Got error during installation of a SQL Server Failover Cluster Instance.

Error Message

The cluster resource ‘SQL Server (INST1)’ could not be brought online due to an error bringing the dependency resource ‘SQL Network Name(USMSSQLDB1)’ online. Refer to the Cluster Events in the Failover Cluster Manager for more information.

Cause

Most common cause of the Network Name resource failure is insufficient permissions. More specifically, the permission "Create Computer Objects" has not been granted to the Cluster Name Object (CNO).

Resolution

We must grant the permissions "Read all properties" and "Create Computer objects" to the CNO via the container. Here’s an example of granting the required permissions:

*** For this we need Admin permission on AD Server.

  1. Open the Active Directory Users and Computers Snap-in (dsa.msc).
  2. Locate “Computers” container.
  3. Make sure "Advanced Features" is selected.
  4. Open the properties of the container and click the "Security" tab. Click "Add" and add the CNO. Make sure to select “Computers” option in the “Object Types” window.
  5. Click "Advanced", highlight the CNO, and click "Edit".
  6. Install SQL Cluster now.