Having a promblem installing SQL 2014 on a Windows 2012 Failover Cluster Servers Nodes

  • I have trying everything, Perstaging the SQL Network name with the right permissions and I'm still this error Log Name: System

    Source: Microsoft-Windows-FailoverClustering

    Date: 4/14/2016 2:43:48 PM

    Event ID: 1194

    Task Category: Network Name Resource

    Level: Error

    Keywords:

    User: SYSTEM

    Computer: BLUESQLNODE02.BLUESKY-INC.COM

    Description:

    Cluster network name resource 'SQL Network Name (VSSQL2014)' failed to create its associated computer object in domain 'BLUESKY-INC.COM' during: Resource online.

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

  • jharris215 (4/15/2016)


    I have trying everything, Perstaging the SQL Network name with the right permissions and I'm still this error Log Name: System

    Source: Microsoft-Windows-FailoverClustering

    Date: 4/14/2016 2:43:48 PM

    Event ID: 1194

    Task Category: Network Name Resource

    Level: Error

    Keywords:

    User: SYSTEM

    Computer: BLUESQLNODE02.BLUESKY-INC.COM

    Description:

    Cluster network name resource 'SQL Network Name (VSSQL2014)' failed to create its associated computer object in domain 'BLUESKY-INC.COM' during: Resource online.

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

    Are you running the SQL Server Service as a NT AUTHORITY\SYSTEM? Pretty certain one has to provide a domain user account instead of the local one.

    😎

  • Installing SQL 2014 with domain user account, the domain/user account has been added to both cluster node local Administrators Group. I get the same result if I use the Domain Administrator.

  • You either have to have the rights to create computer objects in AD for the cluster and for the SQL VM, or else you must pre-create those objects. The error indicates that you don't have rights and the computer objects for the VName don't exist.

  • Error is happening because your Cluster account don't have sufficient Permission. There are two things that you can ask your Active Directory team to do.

    1) Give Necessary rights to your cluster [CNO]

    2) Prestage your SQL Server Virtual Name [VCO] account and grant the Cluster proper permission on the prestage SQL Server Virtual Name

    Refer below link for more detail

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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply