June 10, 2013 at 6:11 pm
After making the changes to the xml file to have the cluster name in all the nodes, can i connect IS from SSMS using Cluster name or individvual node name?
select @@servername gives me SQL name of cluster which i have added in the xml file.
June 10, 2013 at 9:46 pm
Let me start by saying that I have read up on this but haven't actually implemented SSIS on a cluster.
SSIS is not a cluster aware service and MS do not recommend clustering SSIS (have a look at http://msdn.microsoft.com/en-us/library/ms345193(v=sql.105).aspx)
The change you made is simply telling the instance of SSIS the name of the server that contains the MSDB database (that SSIS will be using when stored packages). It just happens that that instance of the database engine (not SSIS) is a clustered instance.
When you connect to SSIS you will still be using a (physical) server name.
If that server happens to fail, then you may end up without an instance of SSIS that is usable.
You may need to consider installing an instance of SSIS onto the other node(s) in the cluster so that if a server fails, you still have a SSIS instance. If you deploy packages to the file system, you should will need to do the deployment on each server that has SSIS on it (I am not sure whether there is a way to have each SSIS installation view the same folder from a shared drive...Perhaps someone with a little more experience doing this can help out here)
June 11, 2013 at 4:32 am
you can connect using the virtual name, so you don't need to know which node is active. If you do know which node is active you can connect by that as well.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply