• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 34
  • Last Modified:

Windows Server 2012 Cluster

Hi Experts,

I am creating a two nodes cluster with two Windows server 2012 R2 servers.

My plan is to create a SQl cluster after I finished creating this Windows Cluster.

Any suggestions on how to accomplish this goal?

I
0
Teavana
Asked:
Teavana
3 Solutions
 
Manikandan NarayanswamySecurity Specialist & IBM Security GuardiumCommented:
Hi,

Find the below links for creating SQL Failover Cluster.

https://msdn.microsoft.com/en-us/library/ms179530.aspx
https://msdn.microsoft.com/en-us/library/ms179410(v=sql.105).aspx

Thanks
Manikandan
0
 
Ryan McCauleyData and Analytics ManagerCommented:
I like this walkthrough as it's a bit more colorful and walks you through the actual setup screens, though there's not as much explanation on individual tabs and options, just a basic walkthrough:

http://blogs.technet.com/b/meamcs/archive/2013/02/15/sql-2012-failover-cluster-build-step-by-step-part-1-installing-sql-2012.aspx
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What kind of suggestions do you need apart from the step by step installation?
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
TeavanaAuthor Commented:
Thank you all for your responses, I appreciate it.  I am having an issue with creating the actual Windows cluster part of this project.

Do I need to configure a separate server (server #3) to create an ISCSI target with the clustered drive or can I use one of the two nodes ?

Thanks
0
 
Manikandan NarayanswamySecurity Specialist & IBM Security GuardiumCommented:
Hi,

You can create ISCSI target on those 2 nodes itself. However i would recommend to create it on the Server 3. Refer the below link for the same. Since it's going to be added on the Cluster and you're planning for the SQL Server Failover cluster. I would recommend to have this ISCSI on Server 3

http://blogs.technet.com/b/babulalghule/archive/2013/02/16/how-to-configure-two-node-windows-server-2012-cluster-on-virtual-machines-for-testing.aspx

Thanks
Manikandan
0
 
TeavanaAuthor Commented:
Sorry for the delay. I will close this out shortly
0
 
TeavanaAuthor Commented:
Thank you, I appreciate your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now