Managing a Microsoft SQL Integration Server

To achieve this, do the following:

  1. Login to the eG admin interface.
  2. Follow the Infrastructure -> Components -> Add/Modify menu sequence.
  3. In the page that appears next, select Microsoft SQL Integration Server as the Component type and click the Add New Component button.
  4. Figure 3 then appears.

    Figure 3 : Adding a Microsoft SQL Integration server for monitoring

  5. In Figure 3, specify the following:

    • Host IP/Name: SSIS can be installed with the Microsoft SQL server – i.e., on the same host as that of the Microsoft SQL server - or on a different host. If SSIS is co-located with the Microsoft SQL server, then make sure that you manage the Microsoft SQL Integration Server component in eG Enterprise using the IP/host name of that Microsoft SQL server. On the other hand, if SSIS is installed on a different host, then make sure you manage the Microsoft SQL Integration Server component in eG using the IP/host name of that host.
    • Nick name: Assign a unique nick name to the target report server.
    • Port number: Specify the port at which the target SSIS listens. This is port 2383 by default. You can override this default value, if there is a change in the SSIS port. Before making the change, figure out the exact port at which SSIS listens.
    • Agentless: Make sure that this check box is deselected, as agent- based monitoring is recommended.
    • Internal Agent Assignment: Set it to Auto.
    • External Agents: Assign one/more external agents to the SSIS  being added.
  6. Next, click the Add button in Figure 3 to save the changes.