Solved

How do I setup a Active Active SQL Cluster in Windows 2008 server

Posted on 2009-04-09
2
676 Views
Last Modified: 2012-05-06
Hi ,
I have set up three virtual servers(Windows 2008 enterprise Edition) with fail over clustering feature installed and the cluster is also created by adding the three servers as three nodes..Now I would like to know the steps to create ACTIVE/ACTIVE SQL cluster ..(I have already implemented the Active /Passive set up for sql and is working fine)....

Please help
Thanks
PK

0
Comment
Question by:pappan73
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
ashwin_kumar525 earned 125 total points
ID: 24114815
Active/Active means nothing but installing another instance of SQL on to the same nodes, 1 node will be active for instance1 and another node will be active for instance 2. Follow the same procedure as if yo were installing it again and this time install SQL with a named instance.

May be in your case, you need to setup three instances of SQL so that each node can be active for each instance.

any further questions?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

730 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