.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is it possble to create Active-Active Cluster in SQL Server 2008R2

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

Hi All,

Another question...
I am new to SQL Clustering.

Can we create Active-Active cluster on SQL Server 2008 R2 Server, which will be having facility to loadbalancing Databases on Clustered Hardware, i.e. some Databases will be on SQL_Cluster_Host_A and Some will be on SQL_Cluster_Host_B.

Or is there any way to configure the above thing?


SQL_Cluster_Host_A will host Database 1, and SQL_Cluster_Host_B will host Database 6,7,8,9,10.
When Host A will fail all DBs will goto Host B, and vise versa.


View Complete Post

More Related Resource Links

Action required on SQL Server side(Active /Passive) cluster,when Upgrade iscsci Upgrde.


Hi all

Storage engineers are planning to Upgrade storage Drive and that storage using for SQL Server 2005 Active /Passive cluster.

as DBA what action I have to take.

I am planning

1.Backup all Databases.(Inluding system)

2.Takning all Databases OFFLINE(make sure no body using Databases)


3.Stopping Instance and Agent .

which is the best way.


any advise is helpful for me.


SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).


Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).

1.I have already have SQL Server 2000 SP4 Installation.
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?


Thanks in advance


Active Server Pages+: ASP+ Improves Web App Deployment, Scalability, Security, and Reliability


ASP has been rebuilt from the ground up. The result? Active Server Pages+. ASP+, with a host of new features, provides for easier to write, cleaner code that's simple to reuse and share. ASP+ boosts performance and scalability by offering access to complied languages; development is more intuitive thanks to Web Forms; and an object-oriented foundation facilitates reuse. Other important features include page events, Web Controls, and caching. Server Controls and improvements in data binding are also new with ASP+. Libraries for use with ASP+, and the Microsoft .NET Framework which allows custom business functions to be exposed over the Web, provide more new development opportunities.

Dave Sussman

MSDN Magazine September 2000

Windows 2008 R2/SQL 2008 SP1 CU5 active/active cluster keeps failing

I have set up many of the same clusters in the last few months, but this cluster specifically has been having lots of problems lately.  OS: Windows Server 2008 R2 latest patches SQL: SQL Server 2008 SP1 CU5 (version: 10.0.2746) Disks: VMAX SAN In the very beginning when I set up the cluster, the cluster validation kept failing when I tried to add a node.  Turned out that we had to unjoin the servers from the domain and rejoin.  Right after that the cluster validation succeeded, the second node joined the cluster, and quorum was changed to "Node and Disk Majority".  SQL was installed and set up as active/active (one sql instance on each node).  No issues then until SQL server was actually in use.  Symptoms: SQL server has heavy ETL processing plus being a subscriber of a sql replication.  The following errors first started on 4/24 when I set up sql replication (these servers are replication subscribers): EventID: 1127, Source: FailoverCluster, Task Category: Network Manager Cluster network interface 'man1fscl01a - Hartbeat to man1fscl91b' for cluster node 'man1fscl01a' on network 'ClusterHeartBeat' failed. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for failures in any other network comp

how to create groups for the active directory

hello guys,For my web application i have use the directory services to authenticate the users ,every thing works gr8 ,but now i would like to create groups for the active directory and add users to the groups ,is it possible,if yes please help me out .i am using visual studio 2010 web application C#.

Is it possible to configure sharepoint to use active directory service configured in another server

I installed sharepoint in a computer which is not configured as a domain,I want it to use the active directory services in the domain which is another computer

How to query the Active directory using SQL Server 2005

Hi, I am trying to query Active server from Sql Server 2005 and getting error I used following script to create link server EXEC sp_addlinkedserver 'ADSI3', 'Active Directory Services 111', 'ADSDSOObject', 'adsdatasource' and then trying to connect using following statement SELECT   * FROM OpenQuery(ADSI, 'SELECT * FROM ''LDAP://DC=local.mycompany.ca'' WHERE objectCategory=''User'' ') and getting following error An error occurred while preparing the query "SELECT * FROM 'LDAP://DC=local.resound.ca' WHERE objectCategory='User' " for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI". Please let me know if you know How to query the Active directory using SQL Server 2005 Thanks, Raj    Dreaming a world without any war in anywhere

Create SQL Login that utilized Active Directory

Hello SQL Guru, I’m newbie to create SQL Login that utilized Active Directory. I have a SQL Server 2008 Enterprise edition 64-bits that runs in Window Server 2008 R2 Standard Edition 64-bit operating Systems. I configured  the SQL Server 2008 with Window Authentication. Then, I login with built-in Administrator account into computer and connected to my SQL Server 2008.  e.g: Object Explorer displayed COMPUTER NAME\Database Instance Name (SQL Server 10.0.2531 – COMPUTER NAME\Admin Account) Then, I created SQL login on the following: USE AccountingDatabase;GO CREATE USER  DomainName\User Name FOR LOGIN DomainName\User NameGO EXEC sp_addrolemember N’db_datareader’, N’DomainName\User Name’GO I tested it out and the specific login still did not have an access to specific database instance  e.g: “AccountingDatabase” Also, I did not see the “User Mapping” under properties checked/assigned to those specific user. Can anyone help and give me light on best practice. Thanks,Edwin

SQL 2008 Active - Acvite Cluster

I have 2 node windows 2008 cluster server, I installed sql 2008 active - active cluster this is work fine but, when i move one instance to other clusrter server, instance has failed ( SQL Server and SQL Server Agent resusorce) and i received this event log on the server what can i do ?Thank You "The description for Event ID 19019 from source MSSQL$INSTANCE2 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer."  

Issues reinstalling a Second Node (Active/Passive) SQL Server 2005 Lustering

We originally had an Active /Active-Passive Node Cluster; (SQLCLUSTER1 (S1) and SQLCLUSTER2 (S2). After a client who needed access to SQLCLUSTER2 was unable to connect, I discovered that the TCP Ports somehow got corrupted.  I couldn’t find a 1433 port. So, I obviously had to do a reinstall.  NOTE: S1 contains the R and S drives (SANs).  S2 contained the T and U drives (SANs as well).   I used the following site to check my install: http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx  By: Brad McGehee   While installing a failover (active/passive node) everything was going well, until I got to the Cluster Group Selection screen.  Under Available cluster groups showed: Cluster Mgmt Group (this Group contains the Quorum Q drive). Under the Unavailable cluster groups showed:  SQL Cluster Group (SQLCLUSTER1) – Already contains a SQL Virtual Server and the next one, SQLCLUSTER2 – Already contains a SQL Virtual Server. Under Data files:  I tried to place the data on the T: drive and I received an error stating that I cannot put data on the same drive as the Quorum drive.   Prior to the reinstall of S2, I deleted/removed all SQL Server data on S2.  Perhaps, this is where my problem may lie. So, my first question is, do I need to reinstall S2? My second question is, could there be

SQL server 2008R2 install on a server 2008 R2 failover cluster. Other resources won't failover to o

As the subject says, I've built a fresh install w2k8r2 and sql2k8r2 failover cluster. Sql works fine on the primary node, but when I test a failover it breaks. Specifically, if I were to stop the node1 cluster service (causing the cluster to switch to node2), windows changes the cluster DNS appropriatly and moves the shared storage just fine, but sql server doesn't failover.  Server Name, Disk Drives and Other Resources all go offline. I've verified that the advanced policies of the server name, IP, cluster drives all have both nodes checked as possible owners However, Other resources only lists node1 as a possible owner and there appears to be no way to add node2.  Under the Other resources, SQL Server and SQL Server Agent are listed. I'm sorta stumped, I've been combing the forums and have found similar issues, but nothing seems to explain why the two resources won't failover.

Upgrading .net framework and server effect active directory


Hi All,

I want to ask some questions that i doubt.

Now currently, our project using active directory on vb.net 1.1 and server 2003. We will be upgrade to vb.net 3.5 and server 2008.

In this case, 1. We convert all vb.net 1.1 application to vb.net 3.5 and run on server 2003.

Then later on, 2. Our server will upgrade to server 2003 to server 2008.

I would linke to know after doing above two phase will effect on Active Directory code setting in our program.

Can I conver to 1 to 1 withut changing anything in vb.net and server?

Active / Active cluster installation




I have installed 2 -3 times a 2 node active/passive cluster  in both version of sql server 2005 & 2008.

Per the new requirements i have to install Active/Active clusters on both 2005 and 2008.

I have a few challenges in this regard.

1. Do i need to create independent sql groups, cluster groups and msdtc group based on the no of nodes.

2. Can i use default instance names on both the nodes.

3. Can i have multiple instances per node .(If possible means  can i map all the data drives on one node to a single sql group)

3. Any considerations need to be taken care from the memory perspective ? (failover considerations)

4. In an (N+1) multi instance cluster environment is there any possibility to choose the failover between the specified nodes.


It would be great if any one can point me in the right direction by providing any docs or any links or video links for the Active/active cluster installation.






Add a new passive node to set up Active/Active/Passive cluster



We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition.

Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster.


Because the cluster is a production server, I need to know exactly how I add a new node onto the current cluster without breaking anything. Also this is my first time to install a passive node, so it is difficult for me to understand how to install and configure it.


I have already added the physical node onto the cluster group so I can see the new node 'paused' from the Cluster Administrator.  Now I need to install the SQL but I am too nervous to run the installation p

Windows Server 2008 32 and 64bit and Active Directory


By any chance do you if it is recommended to have Sharepoint 2010 and
Active Directory on the same windows 2008 server? Or they have to be on separate servers?

Also, do you know if Windows 2008 32 bit have any conflict communicating
with Windows server 2008 64bit?




Setting up 2 node Active-Active SQL cluster as High availability and database mirroring at database

Hi guys
Please need your inputs and suggestions. I have always worked as junior DBA and have setup the HA but never planned for it. Please need some support here.

We have one main application: Application1 ...which is the sending data to all other application for billing, reporting, processing the orders and other stuff. This application is working right now on two Server.

Server1:  SQL Server 2005 Enterprise Edition  (Total 16 Gb RAM , SQL Server ( 4-12 GB AWE Enabled) and  2Processors (4 core each) and 836 GB of HD )
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend