Microsoft SQL server 2008 R2

Hi

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.

Regards
Brad
ablsysadminAsked:
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

Regards
brad
0
 
strivoliCommented:
Where is the attachment?
0
 
ablsysadminAuthor Commented:
Sorry about that
Detail.zip
0
 
strivoliCommented:
You are welcome. Glad you found the solution yourself. Have a nice time!
0
 
ablsysadminAuthor Commented:
it resolved the problem
0
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.