February 11, 2012 at 10:54 pm
Hi All,
Today while performing SQL cluster installation I got stuck by an issue. After all validation test was passed and installation was going smooth at the end wizard pop up with this beautiful message:
"The cluster resource 'SQL server cluster(STAGE)' could not be brought online.Error: The resource failed to come online due to failure of one or more provider resources. Exception from HRESULT : 0x80071736".
I checked the cluster event log and found below event registered:
"Cluster network name resource 'SQL Network Name (RCVSQLPC1)' failed to create its associated computer object in domain '<my_domain>' 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 'RCDBPC1$' 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 'RCDBPC1$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool ".
**************************
Here are my installation Parameters
**************************
OS: WIN2k8 R2 EE
WIN Cluster Name: RCDBPC1
SQL Virtual Network Name: RCVSQLPC1
Using dedicated resource accounts of all services with local admin periv
Myself have local admin previ on this cluster
Guys please look into this issue, its very urgent. Thanks in advance.
Warm Regards
Rahul Chand.
February 13, 2012 at 4:02 am
The account needs to have the Domain 'Add workstations to Domain' right.
This can be granted on its own via a script, or your account can be added to the 'Account Operators' group on the domain. The Account Operators group has additional rights beyong adding workstation to a domain, but is the lowest-level builting group that has this right.
btw, this requirement is documented somewhere in BOL...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 13, 2012 at 8:55 am
if it is it's very well hidden - although I'll admit searching 2008 R2 BOL is "difficult" it's usually easier to use Google to find entries in BOL I find - even Bing doesn't work very well.
Interestingly I have this error from adding file services to my cluster, haven't got as far as adding SQL Server.
It's all a bit disappointing when you're a domain admin and you get this error - you post clarifies, thanks, I've set our AD guys onto the task!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 13, 2012 at 10:39 am
I always go with creating the computer object in AD prior to doing anything with SQL installation. Then grant full control over that object to the cluster computer name. Eliminates this as an issue.
February 15, 2012 at 3:00 am
for reference this explains, note that there are some differences in windows 2008 r2 clustering.
http://technet.microsoft.com/en-us/library/cc731002(v=ws.10).aspx
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 17, 2012 at 3:40 pm
you seems to have missed cluster validation report, if you do not have rights it will certainly tell that in report....check that report again
here's the location: systemroot\Cluster\Reports
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply