.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

20,000 foot view: Sql Server clustering vs. Windows OS Clustering

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I read that Sql Server Failover requires Windows Sevrer clustering to be in place first. (The former builds on the latter). Why is this the case? In other words, what does "sql server clustering" bring to the mix  that normal Windows clustering doesn't supply? TIA, Barkingdog  

View Complete Post

More Related Resource Links

In windows server 2008 standard edition feature Failover clustering is not looking

In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

SQL Server 2008 R2 clustering with windows storage server 2008



I want to implement a full redundant of SQL server for our client. My current topology is: 2 failover cluster of SQL server on 2 different physical servers, and 1 (HP 1000 series) with windows storage server 2008 connected to the SQL servers on SAN.

Now, i want to implement a full availability. I need to add another windows storage server 2008 (to prevent system down in case of crash of first windows storage). My question is, is this available and feasible? what are the requirements?? is there any scenario on the internet that help in implementing such solutions? and is it solid infrastructure that could provide 99.9% ?

Your help is highly appreciated..

Best Regards,

Clustering of Sql server

Hi Everybody, please answer this questions this will be very helpful to me     1. discuss at a high level how to add a new node to an existing SQL cluster in both SQL 2008 and SQL 2005. Begin with SQL 2005.   2. You are a DBA.  The SAN Admin has provisioned a LUN on the SAN and presented it to the nodes and made it clustered storage. At a high level, in either 2005 or 2008 walk through adding the new storage to the SQL instance and what is very important not to forget?   3. Beginning in 2005, there is a SERVERPROPERTY we can now use in T-SQL to discover which node the SQL instance is running on?     Thank you Regards rcnj

SQL Server 2008 R2 Clustering Questions?

Hi All, I have got bit Idea for my question from http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/bff2b555-f25e-4644-a58f-264611818971 I have several questions 1. We have two Serves with Different Configuration (Server Model, CPU, Memory, etc.). Can we do Active-Active Failover Clustering on the same? 2. Can we do Database Level Clustering in SQL Serve 2008 R2 3. Where I will get Documentation for Clustering SQL Serve 2008 R2? Thanks, Ashish K India  

Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

I have already set up a Windows Server 2008 R2 Enterprise x64 with Hyper-V installed for trying out different features in SQL Server.  I'm interesting in trying out SQL Server Clustering.  I have only set up Windows 7 Enterprise x64, Windows 7 Pro x64,  and Windows XP PRO SP2 x86 VMs.  Can I use this VMs for SQL Server 2005 or 2008 Clustering?  Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

Windows 2008 R2 Clustering docs

Evening, Can someone point me to a step-by-step doc to set up clustering on a Windows 2008 R2 server. Need doc(s) to first install clustering on the server and then doc(s) to install a SQL Server cluster on the server. Thanks!

SQLServer 2008 install failure for clustering on Server 2008 R2 with clustering

Where Did i go wrong ?? everything tests okay..It just fails to install to the shared drive, nothing ever gets written to the disk.. Im so stuck..
Reporting services, shared services, books on line.. all install great..Database engine install just bombs.

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068774911
  Exit facility code:            1201
  Exit error code:               1
  Exit message:                  Failed: see details below
  Start time:                    2010-09-29 16:10:37
  End time:                      2010-09-29 16:26:00
  Requested action:              InstallFailoverCluster
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100929_160832\sql_engine_core_shared_Cpu64_1

SQL Server 2008 GEO/Multisite Clustering


I would like to know when and if SQL Sever 2008 will support multisite clustering and how to achive this. I have already installed/tested the basic multisite clustering for static data but would like a more detailed document on the procedures. everything so far have been general high level with papers indicating it can be done but give no real direction on the configuration.

SSRS 2008 and Windows Clustering


I am trying to do SSRS scale out deployment on our Cluster. I am confused in which way I should proceed, based on what I have read and done, i am having two ideas. 

FYI:node1 and node 2 are clustered and node3 has SAN.The configuration is active-active configuration. The SQL server clustering works fine. Now, I have to add SSRS  functionality to the cluster. SSRS is not cluster aware, so I have to do a scale out deployment.

Here is my Plan A: 

  1.Install SSRS on both the nodes (node1, node2) and have them pointing to the same database or  same report database instance. Have NLB on top of it.  I guess NLB is built in feautre in microsoft Windows Server 2008 and it supports this.

Here is plan B: 

 2. have two more machines (node 4, node 5) and install report server on them pointing to the same Database on cluster.Have NLB on top off it. 

Any help is greatly appreciated.

Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

{ End Bracket }: Customize Windows Home Server


Chris Gray discusses custom applications he's developed for Windows Home Server and explores applications for energy savings.

Chris Gray

MSDN Magazine July 2008

Built For Speed: Develop Turbocharged Apps For Windows Compute Cluster Server


This article explores the services provided by Compute Cluster Server 2003 and the tools provided by Visual Studio 2005 that will help you develop High-Perfomance Computing applications.

Rich Ciapala

MSDN Magazine April 2006

Windows Server 2003: Discover Improved System Info, New Kernel, Debugging, Security, and UI APIs


There's a lot to say about Windows Server 2003. First of all, it's the first operating system with built-in .NET Framework support, and it's the first 64-bit OS from Microsoft. But wait, there's more! There are lots of new features and APIs in this version as well. For instance, Windows Server 2003 features Hot Add Memory and a number of other arcane new tidbits. There are new APIs for handling threads, directories, and files, and new features like the low fragmentation heap for managing memory and system information. There's vectored exception handling and new UI APIs as well.OS internals expert Matt Pietrek takes a look at the additions he finds most interesting and useful so you'll have a good place to start when you dive into Windows Server 2003.

Matt Pietrek

MSDN Magazine June 2003

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