Unable to install SQL 2008 on Windows Server 2012 Failover Cluster

Unable to install SQL 2008 on Windows Server 2012 Failover Cluster.

Scenario : If you are trying to configure SQL 2008 Cluster on Windows 2012 / 2012 R2 Clusters, You may get below errors during installation.

SQL Error 1

SQL Error 1

SQL Error 2

SQL Error 2

SQL Error 3

SQL Error 3

If you refer the Event logs / Cluster Logs / SQL Installation logs, You might get below logs for troubleshooting.

Event Logs :
The system failed to register pointer (PTR) resource records (RRs) for network adapter
with settings, Event ID : 8013, 1014

Note : ipconfig /registerdns will fail if you try to update manually, But it will fails with above event ID’s.

Cluster Logs :
Cluster network name resource ‘Cluster Name’ failed registration of one or more associated DNS name(s) for the following reason:
The handle is invalid. Ensure that the network adapters associated with dependent IP address resources are configured with at least one accessible DNS server.

Cluster network name resource ‘Cluster Name’ encountered an error logging on to the domain. The reason for the failure was:
‘Unable to logon to the computer object CNONAME$’. The error code was ‘1073741717’.
Ensure that a domain controller is accessible to this node within the configured domain.

Cluster network name resource ‘CLUSTER RESOURCE’ failed registration of one or more associated DNS name(s) for the following reason:
The handle is invalid. Ensure that the network adapters associated with dependent IP address resources are configured with at least one accessible DNS server.

SQL Installation Logs :

Cluster_IsOnline
Verifies that the cluster service is online. Failed The SQL Server failover cluster services is not online, or the cluster cannot be accessed from one of its nodes. To continue, determine why the cluster is not online and rerun Setup. Do not rerun the rule because the rule cannot detect a cluster environment.

Cluster_SharedDiskFacet
Checks whether the cluster on a computer has at least one shared disk available. Failed The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.

Cluster_VerifyForErrors
Checks if the cluster has been verified and if there are any errors or failures reported in the verification report. Failed The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748 or SQL Server Books Online for more information.

 

Resolution :   Simple PowerShell command fixed my issue, Finally able to install SQL 2008 on Server 2012 R2.

(Run PowerShell in Administrator mode)

Install-WindowsFeature -Name RSAT-Clustering-AutomationServer

 

Advertisements
This entry was posted in General, Manjunath Sullad, Server, Windows and tagged , , , , , , , , , , , , , , , , . Bookmark the permalink.

One Response to Unable to install SQL 2008 on Windows Server 2012 Failover Cluster

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s