Solved

Failover Clustering server 2012

Posted on 2014-04-15
8
623 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
A procedure for exporting installed hotfix details of remote computers using powershell
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 installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

821 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