Solved

Failover Clustering server 2012

Posted on 2014-04-15
8
693 Views
Last Modified: 2014-05-03
We're working on creating a failover cluster on server 2012R2 in order to create a SQL 2012 cluster.  We have two 2012R2 servers in a virtual test environment. Both my DBA and I are new to server and SQL 2012.
We had some problems with the cluster creation so have removed/deleted/dropped the cluster and started again.
Now, we're unable to start the cluster service.  We've tried the log on as local system account, then specific AD accounts created to run as a service.  I even granted myself (a domain admin) permission to log in as a service and still received the attached error.
Does anyone have any idea what priviledge is needed?
ClusterServiceStartError.pdf
0
Comment
Question by:skbarnard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 37

Expert Comment

by:Mahesh
ID: 40002170
Ensure that domain account used to create cluster is member of local administrators group on both servers and try
Also logon to server in domain only

Lastly ensure that account used to create cluster is having rights to create computer object in domain, otherwise it will create issues

You may grant this domain account "add workstation to domain" user rights in default domain policy
OR
if you find any issues while creating cluster virtual object in AD, you can Prestage cluster virtual computer account in active directory

Check below article for more info
http://blogs.msdn.com/b/clustering/archive/2008/08/19/8877483.aspx
http://technet.microsoft.com/en-us/library/cc731002.aspx

Also ensure that you disable windows firewall for all profiles on both servers prior to start the cluster wizard

Mahesh.
0
 

Author Comment

by:skbarnard
ID: 40002375
May I ask a stupid question -- what do you mean by logging into the server in domain only?
These are virtual servers so my only access is through RDP.
0
 
LVL 37

Expert Comment

by:Mahesh
ID: 40003199
That is right, what I mean RDP into server with domain account only that is having local administrator rights on server
In other words that domain account must be member of local administrators group on servers
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:skbarnard
ID: 40005047
I've pretty much done everything suggested and in the article here.  
I was letting our DBA create the cluster for experience but also because we're doing this to get to the point where we can create a SQL cluster.
We were able to create the failover cluster but were unable to start the cluster service because we hadn't added all the permissions outlined in the above article.
So, we deleted the cluster so we could start over. We've done the 'prestaging' before running the create cluster wizard again.  I'm running the create cluster wizard and I'm part of the domain admins group so permissions shouldn't be an issue.
However, now I'm not getting the attached error when trying to create the cluster.
The error states "the system can not find the file specified".  Any idea as to what file it's looking for?
ClusterCreationError.pdf
0
 
LVL 37

Expert Comment

by:Mahesh
ID: 40005092
Check below article and ensure that TCP and UDP 464 port is open from cluster servers to domain controllers
http://support.microsoft.com/kb/2830510

Also try workaround in below article might help
http://social.technet.microsoft.com/Forums/en-US/3593fcd2-523f-4561-b8f6-7481b77554e0/get-error-when-trying-to-complete-cluster-setup-part-of-log-included?forum=winserverClustering

Mahesh.
0
 

Author Comment

by:skbarnard
ID: 40005378
We aren't blocking any ports, the firewall on both servers for the cluster are off.  I issued the command cluster node /force but get this error: 'cluster' is not recognized as an internal or external command, operable program or batch file.
I've tried several powershell commands -- get-cluster clustername but it doesn't find the cluster, remove-cluster clustername but the cluster service needs to be running in order to remove it.
I've tried to add a cluster node using add-clusternode cmdlet but again the cluster service needs to be running for this to work.
Since the cluster isn't found when issuing the 'get-cluster' cmdlet, I tried to create a cluster (through the wizard) and get the message: 'the computer, computername, is joined to the cluster'.
At this point, I'm frustrated enought that I'm about ready to just reinstall the OS but it seems to me there has to be some command, cmdlet that can be run to manually remove/delete the cluster so we can start over (yet again)
Waiting for any input.
0
 

Accepted Solution

by:
skbarnard earned 0 total points
ID: 40027634
We ultimately had to rebuild (reinstall) the servers then the failover cluster creation worked like a champ.
0
 

Author Closing Comment

by:skbarnard
ID: 40039028
While the suggestions and articles given were good, nothing worked for us which is why we just chose to rebuild the server (it's a virtual environment)
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

This article will review the basic installation and configuration for Windows Software Update Services (WSUS) in a Windows 2012 R2 environment.  WSUS is a Microsoft tool that allows administrators to manage and control updates to be approved and ins…
A procedure for exporting installed hotfix details of remote computers using powershell
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

636 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