Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an Active/Active SQL Server 2008 R2 cluster. There are two named instances on each node and no default instance.

I need to deploy SSIS packages to the different instances. To do this, I needed to modify the MsDtsSrvr.ini.xml file to add the instance names so they would be seen by BIDS and SSMS. I put all 4 instance names in that XML file (on both nodes) and restarted SSIS on both nodes. I can now see the folder for each instance when connecting to any instance in SSMS through an Integration Services connection. However, clicking the 2 instance names that are on the other node generates a login failure since they are not active on the current node. Maybe this is just an inconvenience, but am I going to run into any issues with this setup? Or is there a way to do it that makes more sense?

share|improve this question
add comment

1 Answer

I dont see anything wrong in your setup. To be fair, this is the correct way of setting up SSIS in a clustered environment.

Read up SSIS and clustering: What you should do instead

Also for the login failure, its worth to check the Windows Server 2008 R2's firewall rules to allow an inbound rule for either the msdtssrvr.exe executable or the DCOM port SSIS listens on.

share|improve this answer
    
That's great article! Thanks for the link. –  SomeGuy May 9 '13 at 17:29
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.