.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

SQL cluster resources getting failed often

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi We have an active-passive cluster setup in our environment for the SQL application. Both the servers are windows 2000 SP4. In the last 24 hours the SQL cluster resources have failed twice. I am not sure of the correct tme nor the correct log location of where the resources failed.Please find below the cluster logs of the day on which the failure happened. Please find the logs in the below link: http://rapidshare.com/files/414371495/New_Text_Document__2_.txt

View Complete Post

More Related Resource Links

Any issues removing backup mount point cluster resources from SQL Server dependencies?

Win 2003, SQL 2005/SQL2008 64 bit enterprise failover cluster with 3 nodes and 6 instances. The mount points configured as cluster resources for the data/backup/logs. The entire cluster mount points are SAN replicated to a DR Site. But backup drives/LUNs are excluded from the replication. All the disk resources including backup LUNs are set to dependencies on the SQL Server server. The SQL Server is not coming on-line in the DR Site due to unavailability of the backup LUNs (failed resources). As per the documentation all the disk resources must be set to dependencies (http://support.microsoft.com/kb/835185). Thought it did not specifically mentions only Data/Log mount points and/or the backup LUNs as well. "The SQL Server 2005 resource depends on the SQL network name resource and the physical disk resources that hold its data. When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over. "     What if I remove the backup LUNs from dependencies list. This will allow me to recover the SQL Server

Accidentally deleted cluster resources

Hi, Am new to cluster as well as SQL. I have a task to do restoration on a W2K3 Cluster, I have created a new disk partition and manage to restore my DB. But when I remove the disk parition resources, I have deleted the dependency resources, SQL Server and SQL Server Agent. Now I cannot access to the DB through Management Studio. I have tried adding back the 2 resources but was unsuccessful at bringing it online. Some error includes: Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103. TDSSNIClient initialization failed with error 0x103, status code 0xa. Any help will be great.  

SQL node remove failed on Cluster :The state of your SQL Server installation was not changed after t

HI guys , Have you faced this .I am not able to remove the SQL Server 2008 ENT node .The error is : Overall summary:   Final result:                  Failed: see details below   Exit code (Decimal):           -2068643838   Exit facility code:            1203   Exit error code:               2   Exit message:                  The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.   Start time:                    2010-09-12 09:40:40   End time:                      2010-09-12 09:48:26   Requested action:              RemoveNode The details.txt shows the same error in a different way : Running Action: CloseUI 2010-09-12 09:44:44 Slp: Stop action skipped in UI

Setup Error - Failed to load resources from resource file

I tried to install The Lord of the Rings Online, but it always gives me the message (translated in english) that i need to install Net Framwork v1.1.4322. "ok, that's no problem" i thought, but every time i try to install Net Framework (any version) there are errors when trying to install it. With the 1.1 setup, it tells me "Setup Error - Failed to load resources from resource file", the 2.0 setup tells me that it is already installed (o.O?) but i can't see it in the "uninstall programs" list and the 3.0 and 3.5 just won't start. Nothing happens. I tried to install Net framework 4.0 beta which works fine but LotRO keeps telling me the same error message (i think because version 1.1 isn't included in higher versions)I'm running Windows 7 32 bit Ultimate: 2GB Ram, Intel Core duo e6750, GeForce 8800 gts (512 mb)Please help me :)

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.

SQL 2008 R2 cluster installation failure - Failed to find shared disks



The validation tests in the SQL 2008R2 cluster installation (running Windows 2008 R2) fails with the following error. The cluster has one root mount point with multiple mount points :

"The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available'.

The "Detail.txt" log has alot of "access is denied" errors and here is just a sample. Any ideas what might be causing this issue?

2010-09-29 12:54:08 Slp: Initializing rule      : Cluster shared disk available check
2010-09-29 12:54:08 Slp: Rule applied features  : ALL
2010-09-29 12:54:08 Slp: Rule is will be executed  : True
2010-09-29 12:54:08 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterSharedDiskFacet
2010-09-29 12:54:09 Slp: The disk resource 'QUORUM' cannot be used as a shared disk because it's a cluster quorum drive.
2010-09-29 12:54:09 Slp: Mount point status for disk 'QUORUM' could not be determined.  Reason: 'The disk resource 'QUORUM' cannot be used because it is a cluster quorum drive.'
2010-09-29 12:54:09 Slp: System Error: 5 trying to find mount points at path \\?\Volume{e1f5ca48-c798-11df-9401-0026b975df1

SQL server 2008 cluster install error - The resource failed to come online due to the failure of o


Hi ,

I ran into the following error when trying to install sql server 2008 cluster (node 1) on windows 2008

The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)

Any insight on this issue is greatly appreciated





cluster installation failed - sql server 2005


when i install sql server 2005 in cluster. I have error at

Setup process screen --> the selected components are being configured.

all the components are failed.

I am using domain account with administrator account privilege on both server

OS : windows server 2008 on virtual machine


Note : when i install sql server agent is enable to select during setup..



Cluster Fail-over - Failed to bring secondary node online ??



Server : Windows server 2008

DB Server : SQL Server 2008 (SP1)


Here are the series of events which happened.

1.) Event ID: 1135

Cluster node 'XYZ' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. 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 adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.

2.) Event ID: 1049

     Cluster IP address resource 'SQL IP Address 1 (XYZ)' cannot be brought online because a duplicate IP address '' was detected on the network.  Please ensure all IP addresses are unique.

3.) Event ID: 1069

     Cluster resource 'SQL IP Address 1 (XYZ)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.

4.) Event ID: 1049

     Cluster IP address resource 'Cluster IP Address' cannot be brought online because a duplicate IP address '' was detected on the network.  Please ensure

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure t

  • I am new to asp.net etc.

I have developed a website that has began to act unusually. I get the following error below.



Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Source Error:


The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:


Error while adding 3rd node to a cluster --- Failed to retrieve data for this request.


Inside a virtual environment running Windows 2008r2 Ent SP1 and SQL 2008r2 RTM.

Inintial cluster build has gone smoothly for a 2 node cluster using iSCSI. Added up a third node to this cluster manually changed quorum model and MsDTC resource was bouncing all well on the three nodes. Sweat started when the third node failed to add into SQL Failover cluster with the given message "Failed to retrieve data for this request" right after clicking add a node.

Sites talk about adding CuP6 and to lower the security but to note all this worked for first & when adding second node, for the moment this was resolved for me after I restarted all the nodes; going from Node3 to 1. For a moment RemoteRegistry service failed to start on node2 and it wount work even on restarts so moved every thing to node1 now the RPC was up on Node2 and I can go further on adding node3 to SQL cluster but as I'm typing it failed again.

As I check the logs they point about failures to write to registry and at time Network Path not found, User credentials used are all same and pings are going well for the entrire set of IP's I have.

Any insights on this are highly appreciated?


One SQL instance was failed for SQL 2005 SP4 patching on 3 nodes cluster


Hi All,


I did SQL 2005 SP4 patch for 4 SQL instances on 3 nodes cluster this morning. The patch on one SQL instance was failed due to permission issue . I login with my adm account which is in local admin group. We have done on test and DR box before and no problem at all. I had to use cluster admin tool to start the sql instance. Actually it has been patched to SP4 after I checked. Then I did failover the instance to another node. The server authentication was changed to windows mode only, all SQL logins failed to access databases. So I had to change the SQL to mix authentication mode and restart the instance.  



How to detect and avoid memory and resources leaks in .NET application

Despite what a lot of people believe, it's easy to introduce memory and resources leaks in .NET applications. The Garbage Collector, or GC for close friends, is not a magician who would completely relieve you from taking care of your memory and resources consumption.

I'll explain in this article why memory leaks exist in .NET and how to avoid them. Don't worry, I won't focus here on the inner workings of the garbage collector and other advanced characteristics of memory and resources management in .NET.

SharePoint 2010 - Top 10 Resources to get you started

This post contains links to download evaluation software, guides, demo virtual machines and lots more, for both Developers and IT Professionals.SharePoint 2010 - Top 10 Resources to get you started

Resources for soup-to-nuts of website development lifecycle



 I'm looking for a website, or book, or some resource that can lead me down the path from website design to implementation/deployment. I know that covers a ton of material, but I am really looking for the bullet points, or high-lights, to make sure that I think of everything. I am mostly fuzzy on security measures and deployment since I haven't been involved in those aspects before.

Background:  I have been a programmer for many years, and with a little over 3 years' experience coding websites in vb.net/asp.net with sql server. Due to recent restructuring/layoffs at our firm, I find myself in the position of lead IT person - I'm feeling a bit underqualified but I feel this is my chance to work hard and step up to it. I'm very good at vb.net, master pages, css, asp.net, sql server. I'm worried that the person who was the lead before was doing a bunch of stuff that I'm not aware of...so I need to start learning more than just the code. I don't need lessons on how to code anything...I need to learn how it all gets put together - the next step up.

thanks for any suggestions!

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

WebMatrix conversion failed when converting from a character string to uniqueidentifier?


I am trying to retrieve xml from a small function in my .cshtml page. Its throwing me an error. This however, runs fine in a console/form environment.

It takes 3 parameters and 1 exception.

myDll.GetXML(year, username, uniqueidentifier, out ex);

When I run this page I get the error, "Conversion failed when converting from a character string to uniqueidentifier."

Or a stack of.

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBeha
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