sql2005 job not work in passive node

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?

Thanks,

 

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

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
were:

- 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?

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.

Scenario

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.

Regards,

Adnan

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.

Thanks!

Hi all experts,

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

http://s961.photobucket.com/albums/ae95/neoswo/?action=view&current=pic.jpg

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.

Regards.

Hi,

I'm starting a small website that will be backed by a database, and will allow a small number of users to authenticate and select an entry in the database, and then view (and optionally update) a corresponding entry (think master-detail).

I have some flexibility in how I'll do this, but I'd really like to incorperate some newer AJAX style coding, eliminating some page postbacks. I think this is a great opportunity to learn the concepts well.

I'll probably go with an ASP.NET 4.0 site. From what I've seen there are MANY ways to go about this:

-WCF Data Services to expose the data, and consume in ASP.NET

-Page methods to expose the data, separate method to update the data

-I'd rather avoid the UpdatePanel because I'm really looking for a full hands-on approach, with learning client side scripting being an objective as well.

Beyond that, it seems that one can use jQuery to build clientside templates, but also one can use the ASP.NET AJAX template engine (in ASP.NET 4.0 I believe).

A concern I have: users should only be able to work with the data exposed via these endpoints if they are logged into the website. Hopefully I can somehow reuse the ASP.NET forms authentication cookie for this purpose. 

Well, I hope I've posted enough to a

Hi all,

     I have a very unique problem, humm i think. I am using a jquery effect that animate bounce effect, i have a line in my javascript pageLoad function $("#UserBrowserInfoDIV").show('bounce'); - the effects run smoothly but what it does is mess up the bolded text in the div. I have try the items inside the div without bolding and it works fine and no render problem but when bolded the text that are bolded is quite messed up, and barely readable.

Please let me know is there anything else i can do i really would like use this effect.

P.S all the effect have the same render problem, and i am using ie8 under compatibility mode.

Thanks

Kabir

Hi,

I try to run a  treeview example from msdn:

http://msdn.microsoft.com/en-us/library/ms529261%28v=VS.85%29.aspx#TreeView_References

I also want to use code from

http://msdn.microsoft.com/en-us/library/ms529288%28v=VS.85%29.aspx

Here is my code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register TagPrefix="mytree"
Namespace="Microsoft.Web.UI.WebControls"
Assembly="Microsoft.Web.UI.WebControls" %>
 
<html>
<head>
</head>
<body>
 <script type="text/javascript" language="javascript">


     function xxx() {


         var myNode = treeview_one.getTreeNode(treeview_one.selectedNodeIndex);
         alert(myNode.getAttribute("Text"));

         //alert("ok");
     }


</script>
<form id="myform" runat="server">
<mytree:treeview id="treeview_one"  runat="server" Child

Hi,

I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
{
  set { /* the code for set */; }
  get { /* the code for get */; }
}

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

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?

The goal of federated security is to provide a mechanism for establishing trust relationships between domains. Platform tools like Windows Identity Foundation (WIF) make it much easier to support this type of identity federation. We show you how.

Michele Leroux Bustamante

MSDN Magazine August 2010