SQL2k5 HA & SSIS

Last Post 13 Feb 2008 05:41 AM by darknessrockson. 8 Replies.

Author

Messages

darknessrocksonNew Member

04 Feb 2008 09:00 AM

ISSUE:
I have SQL2k5 installed on a High Availabilty cluster and have SSIS and SSRS on a third and non-clustered server. I copy the package to the DB instance create a job, and execute said job, I receive the following error:

Yes, Sp1. no minor fix updates. I am planning on updating to SP2 this weekend just to get everything up to current before I place a MS call.

Michael

darknessrocksonNew Member

12 Feb 2008 06:59 AM

Ok I went and upgraded everything to Sql2k5 sp2. Now the versions are:

9.0.3054 - ssis server
9.0.3042 - database server

Executing the Maintenance plan and the job still gets the same error results.

Suggestions?

--Michael

darknessrocksonNew Member

13 Feb 2008 05:41 AM

NO neither node has SSIS installed.

darknessrocksonNew Member

13 Feb 2008 11:28 AM

Ok I am confused, Since it is not a cluster aware service microsoft doesn't support SSIS in failover clustering (Documented but NOT Supported). In the white papers they suggest running non clusterable services out side of the cluster on a separate host. But you can't manage the services with out locally managing it on the host (Double-hop authentication issue), so change the xml file and schedule the job rather than activated it throug ssis snapin. But that doesn't work because ssis needs to be installed on the nodes for the agent to execute the jobs?

So basically it looks like I need to do the non recommended microsoft process and install ssis?

SQLUSANew Member

13 Feb 2008 12:41 PM

>schedule the job rather than activated it throug ssis snapin. But that doesn't work because ssis needs to be installed on the nodes for the agent to execute the jobs?

Yes. SSIS is a server service. If you don't have it, or you stop it, you cannot execute SSIS packages.