how to setup Integration Services on SQL 2005 cluster

Giganews Newsgroups
Subject: how to setup Integration Services on SQL 2005 cluster
Posted by:  denise (deni…@discussions.microsoft.com)
Date: Tue, 27 Feb 2007

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 on my
pc I get error: "apply to target server failed for job".  If I try it using
management studio while on the active node of the cluster I get error:
"failed to create the task, exception from hresult: 0xC0010014
Microsoft.SqlServer.DTSRuntimeWrap".
I installed Integration Services on both nodes and followed instructions in
document ms345193 to configure IS on the cluster, but I must have something
wrong.
Any ideas what I should look at to get this to work? Thanks!

Replies