Solved

Failover Clustering server 2012

Posted on 2014-04-15
8
631 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 36

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 36

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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 36

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Table of Contents: Lesson 1 - Installing Windows Server 2012 (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2012/A_11592-Become-an-Administrator-Installing-Windows-Server-2012.html) Lesson 2 - Configuring Ser…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

828 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