To import a connection

  1. From the HCO for SQL Server interface, click Manage Connections.
  2. On the Import tab, type the full path to and filename of an XML (.xml) file containing the exported connection(s) that you want to import, or click the browse button to select a file.
  3. Click Read Available Connections to populate the list.
  4. Select one or more connections to import. Use Ctrl+Click to select multiple connections.
  5. Click Import.
    Note:
    • If one or more of the selected connections uses a provider other than System.Data.SqlClient for SQL Server connections, or Microsoft OLE DB Provider for DB2 for DB2 connections, the Import button is disabled and you cannot import the connection.
    • When using Azure mode, HCOSS does not support the importation of a DB2 connection. If a DB2 connection is selected, the Import button is disabled and you cannot import the connection.
    • HCOSS cannot import a connection that has the same name as an existing connection. In this case, HCOSS notifies you that the connection already exists, and does not perform the import of that connection.
  6. When the import is complete, click OK to clear the message. You should see the imported connections on the Connection List found on the Connection List tab.