Microsoft SQL server 2008 R2

Posted on 2012-08-22
Last Modified: 2012-08-27

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.

Question by:ablsysadmin
    LVL 19

    Expert Comment

    Where is the attachment?

    Author Comment

    Sorry about that

    Accepted Solution

    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

    LVL 19

    Expert Comment

    You are welcome. Glad you found the solution yourself. Have a nice time!

    Author Closing Comment

    it resolved the problem

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now