.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

Depending on SQL2005 services on Windows 2003 Cluster

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server


We have an SQL2005 cluster that is running ESRI ArcSDE. ESRI suggests that it depends on SQL Agent and this is how we have the resource dependency setup. We had a situation that we had to take SQL Agent offline and then abck online and this caused ArcSDE to stop as well. ArcSDE needs SQL to be active rather than SQL Agent and there could be other occasions that SQL Agent is in trouble and needs to be stopped/started as is used for our database backups. Is there a better dependency we could use or have we setup the dependency in the clustered services incorrectly?




View Complete Post

More Related Resource Links

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?




NLB over windows server 2003 Cluster on the same machine group

Hi Guys, I should install MS SQL 2005 cluster on windows server 2003. There will be 2 servers in the group. Meanwhile i should set up load balancing for web application again there will be 2 servers in the group. My question is the following, as the load of the servers aren't high is it acceptable to setup load balancing and clustering service onto same windows server 2003 machines group. i.e. the same 2 servers will be a member of Load Balancing and MS SQL Clustering groups?   pls advise. thx

Hosting WCF Services (NetTcp and WS-HTTP) on a windows MCSC fail over cluster

Hi I have a set of WCF Services that use the above protocols. How do i host these in a MCSC Cluster and expose them to the clients ? When hosting the service which is the IP i should use ? The Virtual IP of the Cluster ?

Adding a second node to a SQL 2005 Windows 2003 cluster - NewbieQ



I've been asked to replace the hardware for one of our SQL 2005 cluster nodes because of it's age etc etc..  I have evicted the node from the cluster and added in the new one but now have to add the SQL component to it.  I'm not familiar with this bit!  I have found this guide on Technet


Which seems to be exactly what I need but I have a few questions;

1.  Do I install SQL 2005 on the new node and then perform the steps in the guide above or will it be installed as part of the process following the steps above?

2. Will the current active node go offline or anything like that during the installation? 

3. Do I run the setup from the new node or the current active node?

Sorry for all the questions but I'm new the clustering side of things and dont want to mess this bit up

Thanks in advance


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


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  


.Net framework 3.5 Installation and Windows Installer 4.5 in Windows 2003 SP2 Cluster


Hi all

I am ready with Softwares ...I want procede with Installation of SQL Server 2008 R2.

I am Planning to Update nodes with

".Net  framework 3.5 Installation and Windows Installer 4.5 " in Windows 2003 Sp4 Cluster and I am going to start with Passive node.

Before going to do installation I will take care any thing......Please suggest me.





Adding New Storage for new Instance in Windows 2003 Cluster environment.


Hello all

Part of Preparation for adding new Instance in Cluster I required

1. IP   - I got It

2. Network name    - I got It

3.free disk resources     - I got iSCSI drive but I have to intilize now.

Here my question is

I have to Intilize the "iSCSI" from Both ndoes or it is ok if I intilized from Active node.

Please advise me.

Thanks in Advance


SQL 2008 R2 Cluster unattended setup on Windows Server 2003

All the Docs on setup parameters state that the default for FILESTREAMLEVEL is 0 (filestream disabled) however whether it is defaulted or supplied as 0 the setup fails during installation because KB937444 is not applied to W2K3. Presumably this is because even if the filestream is disabled the software is still installed. But if this is a Pre Requisite why is this not validated at the start??

Getting Started with Windows SharePoint Services

Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

New Features in Windows SharePoint Services 3.0

Windows SharePoint Services 3.0 (WSS 3.0) is the next version of WSS 2.0, released on 2007, and Microsoft Office SharePoint Server 2007 (MOSS 2007) is built on top of this. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. WSS 3.0 offers a lot of new features and programmability support. I have consolidated a list of new features and enhancements in the below section:

Cloud Patterns: Designing and Deploying Services for Windows Azure


To better understand how SOA patterns can be applied to Windows Azure deployments, we walk you through a scenario in which a bank moves its services to the cloud.

Thomas Erl, Arman Kurtagic, Herbjörn Wilhelmsen

MSDN Magazine January 2010

Cloud Security: Crypto Services and Data Security in Windows Azure


Many early adopters cloud platforms have questions about security. We review some of the cryptography services and providers in Windows Azure along with some security implications for applications in the cloud.

Jonathan Wiggs

MSDN Magazine January 2010

Windows with C++: Windows Web Services


With the introduction of the Windows Web Services (WWS) API, C++ developers no longer have to think of themselves as second-class citizens in the world of Web Services. In this article, the author explores the features and benefits that the WWS API has to offer.

Kenny Kerr

MSDN Magazine November 2009

Contract-First Web Services: Schema-based Development with Windows Communication Foundation


Schema- first contract-first modeling of Web Services gives you the ability to model your contracts with an XML-centric mindset. This process keeps you focused on universally acceptable types and the hierarchical data structures that can be represented in XML.

Christian Weyer, Buddhike de Silva

MSDN Magazine October 2009

Take Control: Use SharePoint to Manage Your Windows Services


In this article, we show you how to integrate a Windows Services-based solution with SharePoint. The results enable you to provision, start, stop, and remove service instances through SharePoint 3.0 Central Administration.

Pav Cherny

MSDN Magazine April 2009

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