Integraton Services not connecting through Management Studio

  • Ignacio A. Salom Rangel (12/4/2008)


    Javier, just to be sure, Are you able to connect to Integration Services from the first node?

    Which node are you connecting from? My understanding of your issue is:

    1. You have installed Integration Services on each node in an a/p.

    2. You cant connect to Integration Services on passive node.

    3. And get error connecting to MSDN from you local client.

    Okay, so:

    1. I would verify that the services are active on both nodes.

    2. you should re-install SP2 and any other hotfixes you may have installed.

    3. you need to ensure that the Integrated Services instance node you are connecting to is which ever is your active node. Of course your not going to see MSDN on a passive node (if thats what you tried). :w00t:

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • First of all Thanks for the response!

    Network Support and I will be loading SP2 for SQL and Windows this weekend. Hopefully this will help.

    All the questions I'm asking is because all the packages that were running on the 'A' mode is not working on the 'B' mode when failed over. For some reason in my opinion Integration Services when installed intitally was installed on the 'A' mode. This worked fine when running all the SSIS packages. I have read that you should load Integration Services on the 'B' mode as configure Integration Services as cluster resource.

    Hopefully this makes sense.

    Javier

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

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