question

alejandra avatar image
alejandra asked

Error during installation of an SQL server Failover Cluster Instance

Hi. I really need help . Im trying to install an SQL Server instance and I got this error. ![alt text][1] I already check user and CNO permissions .. the CNO had "Read all properties" and "Create Computer objects" . the user that create the instance is an domain administrator and local administrator. any idea , I really apreciate your help. thanks [1]: /storage/temp/2599-img.png
clusterfailover
img.png (10.2 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MAXKA avatar image
MAXKA answered
The 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). The user credentials of the currently logged on user who is creating the Failover Cluster will be used to create the computer objects in Active Directory. The user must have Create Computer Objects permissions to the OU to create the computer objects Option #1 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 demonstration purposes: Option # 2 We can also “Pre-Stage” the VCO, which is useful in situations where the Domain Administrator does not allow the CNO “Read All Properties” and “Create computer Objects” permissions: Please read below 2 articles for same: [Prestage Cluster Computer Objects in Active Directory Domain Services][1] [How to Create a Cluster in a Restrictive Active Directory Environment][2] [1]: https://technet.microsoft.com/en-us/library/dn466519.aspx?f=255&MSPPError=-2147217396 [2]: http://blogs.msdn.com/b/clustering/archive/2012/03/30/10289577.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alejandra avatar image alejandra commented ·
Hi,thanks for your help. I check everything you mention but Im still having the problem. every time you run the installer this message appears in event viewer . alt text as it might affect the installation of SQL Server instance ???
0 Likes 0 ·
alejandra avatar image
alejandra answered
Hi,thanks for your help. I check everything you mention but Im still having the problem. every time you run the installer this message appears in event viewer . ![alt text][1] as it might affect the installation of SQL Server instance ??? [1]: /storage/temp/2612-imgerrorlogin.png

imgerrorlogin.png (14.7 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.