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

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

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

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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


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."  

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?




question about applying 2008 SP1 on a active passive cluster


In the past (SS 2005), I was able to apply patches to to the virtual cluster host and it automatically detected both nodes and applied the patch.  This incurred downtime due to a reboot, but i did not care since this was a new cluster build.

Now, in 2008, the information I am finding implies that you should apply on passive node, perform a failover and then apply on other node.  

I am curious if it is still possible to apply the patch like i did for SS 2005, where I just run the install a single time from the virtual cluster host, thereby letting the installer figure out  it is a cluster and apply to both nodes?

Expansion from an Active/Passive SQL 2008 setup to ... ? (Supporting our growth)

Hi. I'm a sysadmin (or rather Jack of all trades) that also takes care of a MS SQL 2008 (standard) servercluster that is in an Active/Passive setup (2 servers, one active, one standby with files stored on a SAN with dual 10Gbps connection). We are currently hitting the limits of what a single SQL server (on our hardware) can handle. We are growing and our clients are as well. As such, we're starting to see slow-downs on SQL level (a part due to application design, but part simply due to capacity). I've been doing my best to read up on all options, where we can increase performance , yet maintain our current failover capacity . An ideal scenario would be to just make both nodes 'Active' and allow querying on both while their databases remain sync'ed in the event one of them were to fail. There is however no such thing as an "Active/Active" MS SQL 2008 cluster. I've been reading more and more about (Transactional) Replication, Mirroring, Log Shipping and so on, but either it does not really fit to our current situation, or it would require more hardware than I have at my disposal. I'm afraid I don't fully comprehend all the implications of the available technologies. Am I overlooking something? What solution would you suggest? The new setup must be capable of automatically failovering with no (or extremely minimal ) dataloss , yet get better performanc

Moving to Active Directory to 2008 R2 - any issues with MOSS 2007?


Moving to Active Directory to 2008 R2 - any issues with MOSS 2007?

Anybody else running that combination? Any considerations.

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Accessing Active Directory with SQL 2008

I've searched the forum, as was unable to come up with a solution.

How can I access my Active Directory using SQL 2008?

I've tried running Import and Export Data but "OLE DB provider for microsoft directory services" isn't even listed as an option. Do I need to install something extra?

Thanks in advance


Two node SQL 2008 cluster on two Windows 2008 servers


Hi, I want to know if it is possible to setup a two node SQL 2008 Server cluster with a single named instance on two Windows Server 2008 boxes (any version). The  documentation suggests that setting up any type of SQL cluster needs to be on an existing Windows cluster. Would rather not setup a windows cluster if possible.


Any help would be appreciated.

Windows Server 2008 Cluster Disk write caching - SQL Server 2008

I was told by the windows admin that you cannot disable write caching in windows server 2008 when the drives are clustered. Can someone please tell me how to turn it off. I find it very hard to believe you cannot turn it off. i know on a normal server how to do it, by right clicking the drive, properties, hardware, click on the drive, click properties, uncheck write caching...However, this is disabled on my cluster. 
John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

Migration of Analysis Services 2005 Cluster (Windows 2003) to Analysis Services 2005 (Windows 2008)



I need to migrate my SQL Server and Analysis Services cluster from Windows Server 2003 to Windows Server 2008, I have found an article for SQL ID (953200), but I cannot find anything for Analysis Services, does such a guide exist?




SQL Server 2008 windows 2008 sp2 cluster issue?

The Duch windows server 2008 sp2 release notes tell me there is een isue with installing SQL2008 on an W2k8 sp2 cluster:

Jet the English page does not mention this:

Wich on is true? Is there a problem or not?

Hot fixes for Windows 2003 SP2 for Installing SQL Server 2008 R2 In Cluster environment


Hello all

Please some body help me to  find Hot fixes  for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.




Thanks in Advance  


SQL Server 2008 on a Windows Server 2008 Cluster


Dear All,

Could you help to guide me how to configure SQL Server 2008 on a Windows Server 2008 Cluster?




Windows 2008 R2 cluster validation alerts (chkdsk.exe)



I setup a two-node Windows 2008R2 cluster on an iSCSI SAN. The setup went through fine. A few days ago,  the customer power off the iSCSI switches but forgot to shutdown the cluster first. Right now when I run the cluster validation test, this alert show up:

"Cluster Disk X may require running chkdsk.exe as part of the validation process." All the cluster disks have the same alert. I tried to put some cluster disk in maintenance mode and ran chkdsk /F, not error found, but when I ran the validation test again, the same cluster disk still show the alert.

here is my questions:

1. any way to get rid of that alerts during the validation test?

2. I also have an active/active sql 2008 (with sp2) cluster running on top of this cluster. how can I run chkdsk on those cluster disks that have sql instance running on it?

thanks in advance.


Installation problem with SQL 2005 on Windows 2008 R2 x64 Failover Cluster


I have built a Windows 2008 R2 x64 Failover Cluster and I need to install SQL 2005 Enterprise x64.

The SQL installation passes all checks and then fails as soon as it attempts to do the installation.

The error message in the Core(Local) log file is:

CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='0'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2010/0/8 1:6:26, returned true
Running: SetPackageInstallStateAction at: 2010/0/8 1:6:26
Complete: SetPackageInstallStateAction at: 2010/0/8 1:6:26, returned true
Running: DeterminePackageTransformsAction at: 2010/0/8 1:6:26
Complete: DeterminePackageTransformsAction at: 2010/0/8 1:6:26, returned true
Running: ValidateSetupPropertiesAction at: 2010/0/8 1:6:26
Complete: ValidateSetupPropertiesAction at: 2010/0/8 1:6:26, returned true
Running: OpenPipeAction at: 2010/0/8 1:6:26
Complete: OpenPipeAction at: 2010/0/8 1:6:26, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2010/0/8 1:6:26
Complete: CreatePipeAction at: 2010/0/8 1:6:26, returned true
Running: R

Upgrading SQL2008 Cluster Active/Active Failing to upgrade 2nd node


I upgraded the 1st node of a SQL2008 Cluster on Windows 2003 sp2, and this was after correcting a SQL2008 Cluster install by uninstalling and removing a node.   It was stable when I began the R2 install.  The first node went as planned, but it will not move past the setup phase where it does the install of the setup files, and the log shows this:

Running Action: PostMsiTimingConfigAction
2010-11-04 09:52:52 Slp: The object state property 'workflow' is null/empty.
2010-11-04 09:52:52 Slp: Error: Action "PostMsiTimingConfigAction" failed during execution.
2010-11-04 09:52:52 Slp: Completed Action: PostMsiTimingConfigAction, returned False


I had previously tried to install R2 which led to some corruption and required me to correct the 2008 install.  Following the instructions here :



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