.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

Passive node doesn't run scheduled jobs when it becomes the active node

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

I have one cluster with two nodes. For reference, Node A = the normally active node, and Node B = the normally passive node.

When the cluster is running on Node B, scheduled jobs don't run. They work just fine when the cluster is running on Node A.

I have checked that on both nodes, all services are running under the same domain logins, and that both the jobs and the schedules within the jobs are enabled.

Everything else on the SQL seems to be working properly. I'd really like to get this working, but I don't know what else to look into.


@@VERSION: Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)   May 26 2009 14:24:20   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

View Complete Post

More Related Resource Links

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

Bad Install on our second Active/Passive node (SQL2)


Yesterday when I was trying to bind the port 1433 to the IP Address, the Bind didn't work.  I ran 'Netstat -an' and noticed that there wasn't a port 1433 for listening.  I found on MSDN how to manually uninstall a SQL Server Failover Cluster (msdn.microsoft.com/en-us/library/ms180973) .  My question when I proceed is with the uninstall of SQL2 , will this affect our SQL1 Active Node?



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

How to re-enable clustered node from previously Passive back to Active cluster?


Hi all experts,


I pretty new in SQL database along with WinServ clustering, so please mind my knowledge level in the overall process.


Base on the screenshot above, we have currently a single cluster created base in which that is controlling DB1 and DB2. Primarily DB1 would be our Active node whereas DB2 would be our Passive, both have it's own designated Public and Private IP. After a small issue previously in which our cluster service failed, it seems that the failover has taken place in which at the moment is running on DB2, which bears the question now is would it be possible to have DB1 being the Active node without downtime? and what is the process flow to change reactivate it back?

Servers Details:

- Win2k3 Ent Application Server

- Win2k3 Ent DB1&2

- IBM DS5020 SAN Storage

On the disk management on each DB servers, we are not able to see the LUNs in DB1 (shown as Unreadable) whereas on DB2 it is shown as normal, in which we would assume that this is normal since DB2 is the active node.

Thanks for reading & most of my search base on this question ended up in this forum, which I would assume that this is the correct place to ask.


SQL Management Studio not on Passive Node SQL 2008 Cluster

Hello, I would like to be able to use SQL Management Studio on the passive node in our cluster if there's a failover and Passive Node becomes Active Node.  It seems like the Add Node install didn't load SQL Management Studio on our passive node. Any help is appreciated. Thanks,  Morrisos

sql2005 job not work in passive node

We have SQL Server 2005 cluster setup, active/passive, 2 nodes, on Windows
2003. If I try to add a maintenance task using sql management studio .active  node working fine.if active node down Sql agent is not here. so  jobs are not working

sql 2005 cluster ssis not installed passive node


I am doing an SQL Server 2005 Cluster install. The install appeared to go
okay. On the active node everything installed fine. However, when we looked
at the other node only the configuration tools got installed. SQL Server
Management Studio did not get installed. Would anyone know what caused this
and how to install the SQL Server 2005 on a cluser correctly? I understand
that that the management tools only get installed on the primary node.
Should I run setup on the secondary node to install the tools?

I also went through the summary log for the install and  noticed that almost
everything that was installed on the active node was  also installed on the
passive node. The products that did not get installed  on the passive node

- Microsoft SQL Server 2005 Integration Services
- Microsoft SQL Server 2005 Notification Services
- Microsoft SQL Server 2005 Reporting Services
- Microsoft SQL Server 2005 Tools

Should not these have been installed on the passive node as well?

SQL Instance Installation on Passive Node


Dear All,

I need a suggestion from you guys, one of our client asking me about the SQL Server New Instance Installation on SQL Cluster Passive node.



Node 1

SQL Cluster (Active) Connected with SAN Fiber Channel


Node 2

SQL Cluster (Passive) Connected with SAN Fiber Channel


They are asking

Node 2

SQL Cluster (Passive) Connected with SAN Fiber Channel

New Instance of SQL Server (StandAlone) Will Connect with other Fiber Channel SAN Storage


Please let me know is it a good practice or Any Risk on that if we will implement that scenario.





Adnan Khan

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 )

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 :



To install SQL in a passive node

Hi..We have a two node cluster. We have the SQL 2000 SP4 running and now active only in one node as the passive node got something wrong and corrupted. Restoring the backups also didnt work. So we have built up that passive node from scratch. We have to again make this working as a two node cluster. Is this possible to install the SQL in one node merging as a cluster pair while it is already running as a cluster in another node after adding the node in the windows cluster ?

Display homepage node along with child nodes


If the first Sitemap node is your homepage/default and all other nodes are supposed to be children / grandchildren of the first sitemap node in a web.sitemap, how do I set up my web.sitemap to enable me to display my cssFriendlyMenu with the homepage node along with the nodes that are 1 level down from it at the same time as in :

Home   Products   Services   About us


...or is it not possible to have the first sitemap node displayed along with the nodes that are 1 level down from it?  Do I need to have a different starting node rather than my homepage node?

ImageURL SiteMap Node


Hi Can anyone tell me how i can add the ImageURL from a sitemap into a navigation menu, i had this working with webforms but cannot get it to work with mcv

var sbMenuHelper = new StringBuilder();

sbMenuHelper.Append("<ul class='cssMenu'>");

var topLevelNodes = SiteMap.RootNode.ChildNodes;
foreach (SiteMapNode node in topLevelNodes)
    if (SiteMap.CurrentNode == node)
        sbMenuHelper.AppendFormat("<a href='{0}'>{1}</a>", node.Url, helper.Encode(node.Title));

return sbMenuHelper.ToString();

        description="Contact Us"

Addressing a specific node with CSS Friendly Control Adapters


Hello everybody,

I like the concept of the friendly control adapters, but I'm not sure if I can use them for my purpose.
My whole menu basically consist of one image, which itself contains the images for each menu item (is that understandable?).

Each menu item then displays only a certain part of the image.
I do this by shifting the background-position.

#navigation li#home a{
background-position:0px 0px;

/* Registration */
#navigation li#registration a:link, li#registration a:visited {
background-position:-106px -34px;

#navigation li#registration a:hover, li#registration a:focus {
background-position:-106px 0px;

/* Administration */
#navigation li#administration a:link, li#administration a:visited{
background-position:-212px -34px;

#navigation li#administration a:hover, li#administration a:focus{
background-position:-212px 0px;


I would like to do the same now with CSS Friendly, but I don't see how I can address each individual menu item node.
In static HTML I can give each link an ID (i.e. #administration), but I don't see how to do this with the asp:Menu control and CSS Friendly.

Can someone help me?

Thanks a lot,

(Imperfect) Solution to TreeView Postback / Client-Side Node Selection Issue


I've seen this question posted on all corners of the web... "How do I disable "AutoPostBack" on the ASP.NET 2.0 TreeView control?!"  Unfortunately, most of the answers either don't work, miss the point (don't work right), or boil down to "You can't do it."  I happen to know that this behavior worked perfectly in the IEWebControls TreeView that Microsoft released as an add-on prior to ASP.NET 2.0, however.  So I set out to find a solution for the ASP.NET 2.0 TreeView issue.

In a nutshell, the behavior that I and others are looking for is to have a TreeView rendered in a page that allows the user to expand, contract, and select nodes within the TreeView without causing a PostBack to the server.  This implies two things: (1) the most recently-selected node should be recorded as the currently-selected node [i.e., at PostBack time, the most-recently selected node is actually represented as the SelectedNode]; and (2) the selected node should exhibit the SelectedNodeStyle as specified in the TreeView declaration.

It appears that the TreeView engineers saw only two possible outcomes from selecting a leaf node in a tree: (1) immediately posting back to the server, or (2) immediately navigating to another web page.  They apparently did not consider option (3) just allowing selection in-place on the client, while waiting for a click on so

Node probability distibution - values don't sum to 1?

Hi, I am using sequence clustering algorithm and I have checked Node probability distribution (state transition) for one of the cluster. Probability values don't sum to 1. Why? I think they should. Do I miss something?
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