?
Solved

Microsoft SQL server 2008 R2

Posted on 2012-08-22
5
Medium Priority
?
688 Views
Last Modified: 2016-11-23
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
0
Comment
Question by:ablsysadmin
  • 3
  • 2
5 Comments
 
LVL 20

Expert Comment

by:strivoli
ID: 38320385
Where is the attachment?
0
 

Author Comment

by:ablsysadmin
ID: 38320415
Sorry about that
Detail.zip
0
 

Accepted Solution

by:
ablsysadmin earned 0 total points
ID: 38320884
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
 
LVL 20

Expert Comment

by:strivoli
ID: 38320926
You are welcome. Glad you found the solution yourself. Have a nice time!
0
 

Author Closing Comment

by:ablsysadmin
ID: 38335800
it resolved the problem
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

862 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