SQL Agent Fails

  • Hi ,

    I Am getting this error " [LOG] Step 1 of job 'DataFileBk' (0xC2B67F7AA5559B45870B34563AAEEBDC) cannot be run because the SSIS subsystem failed to load. The job has been suspended "

    from the one of the cluster node (node2) where i did not installed the sql server instance . if i enable another node(node1) its working fine . i have installed the sql failover cluster from one of the cluster node (node1) but i did not install the sql client in another machine.

  • If I understand you correctly, you have installed SQL Server on a 2 node cluster and when you failover to node 2 some jobs don't give an SSIS error.

    SSIS is not clustered. That means that unlike the database engine or SSAS, you have to install SSIS manually on the second node. I would also advice to install the client tools on the second node as well.

    If you need to access files from the server make sure they are on the shared disk and that you use the virtual node name in your connection manager.

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply