Solved

Failover Clustering server 2012

Posted on 2014-04-15
8
602 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
  • 5
  • 3
8 Comments
 
LVL 35

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 35

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
 

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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 35

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
What to do when Windows Update is not working correctly? What tools can I use to detect the cause of the malfunction problem? What does this numeric error code mean? These and other questions that you have been asking in the past are answered here (…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
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 …

758 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

20 Experts available now in Live!

Get 1:1 Help Now