Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL Active / Active Clusters

Avatar of Eric
EricFlag for Canada asked on
Microsoft SQL Server 2008Windows Server 2008
11 Comments1 Solution453 ViewsLast Modified:
Hello,

Please forgive me if my questions seems to naive but;

I am pretty familiar with Windows 2008 R2 Clustering. I have read articles, books and saw some videos. But in every one of them were about active/passive clustering.

I am installing SQL 2008 Cluster on two node and i want to make it active/active.

I know that if you configure clusters by default, it is going to be active/passive. Install the SQL 2008 on the first node and then add failover cluster node on the second.

But How can I configure Active / Active 2 node cluster on Windows 2008.

Can anybody send me a link or a book showing how to configure active/active clusters especially SQL 2008.

Thanks and regards

Fiyona