Solved

IIS + MS SQL Clustering (Windows 2012) on Power Edge VRTX with 2 Blades

Posted on 2014-03-21
5
483 Views
Last Modified: 2014-03-31
I want to do clustering between 2 Windows 2012 servers with IIS and MS Sql will be running on power edge VRTX server with two M620 Blades. Which is the best practice  ?
0
Comment
Question by:vijaydawda
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 39946393
Windows cluster
    SQL Server cluster instance ( 2 node)

Windows IIS
    Use SQL for Sessionstate ( use SQL Server in the cluster above)
    then use IIS clsuter as a service
0
 
LVL 1

Author Comment

by:vijaydawda
ID: 39946447
Melih, Could you please explain ?
0
 
LVL 19

Accepted Solution

by:
Melih SARICA earned 500 total points
ID: 39947002
1. Install windows server 2012 on both blades.
2.Install all patches on both.
    Enable IIS feature on both nodes.
3.Add feature windows cluster on node 1.
4.create a cluster on node 1
5.enable cluster feature on node 2
6.Join 2nd node to cluster.
7.Install SQL Fail over Cluster Instance on node 1
8.Add SQL fail over cluster node to node 2(In setup there is a link for adding node)
9.Add IIS application as a service on cluster
0
 
LVL 1

Author Comment

by:vijaydawda
ID: 39947061
Thanks.
Melih, Do i need to configure SQL for Sessionstate  ?
0
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 39947141
yes u must.. Its the only way to handle session states in 2ormore node IIS configuraions
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Whether to use true/false, yes/no or 0/1 11 67
How many transactions can mysql handle? 3 43
running code or pseudo code of table structure 5 30
MySQL Error Code 2 25
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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