Microsoft SQL server 2008 R2


I've been strggling to get a SQL 2008 R2 cluster setup.
I have 2 x Dell R620's with OS loaded on the local disk.
The shared disk is running on a fibre attached SAN.
I've createtd the windows cluster successfully and validated it without errors.
when I attempt the SQL installation, it completes the entire installation and right at the end, throws the below error.

The cluster resource 'SQL Server' 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)

I've attached a copy of the error log file to this question.
And please keep in mind that this is my first installation of SQL.
Any assistance would be appreciated.

Who is Participating?
ablsysadminConnect With a Mentor Author Commented:
Hi Strivoli

thanks for taking an interest in my case.
I've managed to resolve the problem.
it was a permissions issue on the default computers OU on AD.
the relevant service account had permissions to add computer accounts which I believed was all it need but apparently it needed more. I gave the account full rights to the OU and that resolved the problem.

Thanks again

Where is the attachment?
ablsysadminAuthor Commented:
Sorry about that
You are welcome. Glad you found the solution yourself. Have a nice time!
ablsysadminAuthor Commented:
it resolved the problem
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.