August 20, 2010 at 1:11 pm
Hi,
We are installing SQL Server 2008 on Windows 2008 cluster and the installation is failed saying unable bring the SQL instance online.
I noticed the below error in system event viewer errors:
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 8/20/2010 10:10:12 AM
Event ID: 1194
Task Category: Network Name Resource
Level: Error
Keywords:
User: SYSTEM
Computer: SQL2.abc.com
Description:
Cluster network name resource 'SQL Network Name (SQLVS)' failed to create its associated computer object in domain 'abc.com' for the following reason: Unable to create computer account.
The text for the associated error code is: Access is denied.
Please work with your domain administrator to ensure that:
- The cluster identity 'SQLCLUSTER$' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'SQLCLUSTER$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
2.
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 8/20/2010 10:10:12 AM
Event ID: 1069
Task Category: Resource Control Manager
Level: Error
Keywords:
User: SYSTEM
Computer: SQL2.abc.com
Description:
Cluster resource 'SQL Network Name (SQLVS)' in clustered service or application 'SQL Group' failed.
Here, Cluster service account has NOT been added to Administrator group on node SQL2
Does the Cluster service account need to be add to Administrator group??
Please advice
Thanks
August 20, 2010 at 3:47 pm
After my research, came to know that the cluster service no longer runs as a domain account and it did not require to add in local Administrator account.
Question:
Do we need create the Virtual Server name that we want to use in DNS prior to SQL Server 2008 installation?
Because the SQL 2008 installation is failing reporting that it's unable cretae the object SQLVS in AD
Installation Error:
The cluster resource 'SQL Server (INS1)' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)
Event viewer error:
Cluster network name resource 'SQL Network Name (SQLVS)' failed to create its associated computer object in domain 'abc.com' for the following reason: Unable to create computer account.
The text for the associated error code is: Access is denied.
Please work with your domain administrator to ensure that:
- The cluster identity 'SQLCLUSTER$' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'SQLCLUSTER$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
Please advice
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply